The graph below shows the runtimes of all TPC-H queries of PG Nitrous on r5.12xlarge and RDS PostgreSQL on r5d.12xlarge. Results Comparing PG Nitrous to RDS PostgreSQL on systems with equal resources. Instead of using standard PostgreSQL indexes, PG Nitrous replicas use the Swarm64 DA columnstore index. We set up the PG Nitrous instances similar to RDS PostgreSQL, using the same PostgreSQL parameter settings listed above for the similarly equipped instance and scaled-down values for the small instance. We also defined indexes for the TPC-H tables/queries in RDS PostgreSQL, which you can review here. The most relevant changes are listed below: Parameter To the best of our knowledge, the changes give PostgreSQL the best performance when running the TPC-H benchmark in our testing environment. We also made some changes to the default RDS configuration to increase its parallelism and optimize it for query performance. The table below shows a summary of the selected instances and storage configuration for each SUT. the smallest available PG Nitrous instance (16-vCore r5.4xlarge).a similarly equipped PG Nitrous instance (48-vCore r5.12xlarge).In our tests, we ran two experiments comparing the query performance of Amazon RDS PostgreSQL on the smallest possible instance capable of running >70% of the 22 TPC-H queries without timing out, a 48-vCore r5d.12xlarge, versus: Two tests – a small and a large PG Nitrous instance
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |