One post tagged with "postgresql"

This article evaluates the performance of MongoDB, PostgreSQL (two versions), and CockroachDB in handling data insertion and querying tasks. The comparison is based on how these databases manage workloads, emphasizing time taken for data insertion and query execution.

Reference GitHub Repository: For further insights into BSON and JSON performance, refer to the BSON-JSON Bakeoff repository.

Test Overview​

1. Insertion Test:

   • 10,000 documents with a 4,000-byte (4KB) payload were inserted into an indexed field.
   • Two scenarios were tested:
     • Payload stored in a single attribute.
     • Payload distributed across 200 attributes.

2. Query Test:

   • Queried 10,000 IDs from an indexed array.

3. Metrics Measured:

   • Time taken for each operation.
   • Total items retrieved during queries.