Here are setups that add GritDB next to an operational database, and their results. Datagrit tested the reference setups itself. Customer validations use customer data.
Customer validation · financial services
We validated report queries with the customer's real data.
A report query that took 229 seconds on 200,000 rows in the existing PostgreSQL ran in 8.8 seconds on 10 million rows, 50 times the data
Reference setup · in-house test
We timed 22 analytics queries on the same server specification.
Up to 43.5 times faster than PostgreSQL, 9.5 times in total (SF20 · 20 queries)
Reference setup · in-house test
A CDC tool kept GritDB in sync, and we compared query times with PostgreSQL. These are the SF10 results from the same test as the TPC-H comparison.
Up to 21.3 times faster than PostgreSQL, 5.4 times in total (SF10 · 20 queries)
The TPC-H numbers on the cards come from in-house tests derived from TPC-H. They are not official TPC-H results and cannot be compared with published TPC-H results.
Amazon Aurora, Amazon RDS and their logos are trademarks of Amazon.com, Inc. or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission. The Mirae Asset Financial Services logo is a trademark of Mirae Asset Financial Services or its affiliates, and the ModigenceVision logo belongs to ModigenceVision. TPC-H is a trademark of the Transaction Processing Performance Council.
Ask for a discovery meeting or a PoC, and we will get in touch.
