TPCH PostgreSQL Table Partitionning #369
-
Hello everyone, Nice to play with the many capabilities of hammerdb tool. Thanks to the developers ! A question regarding table partitioning when using community PostgreSQL. Is there support for partitioning of large tables in TPCH ? Regards, |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments
-
That is correct, for now HammerDB does not partition the TPC-H schema for any database. This is because initially with the commerical databases partitioning is a paid option and not necessarily supported in all environments, therefore HammerDB built a schema that didn't rely on additional options. Also the open source databases didn't support analytic features such as column store or partitioning. Therefore for now the way to partition the schema is to use the datagen option https://www.hammerdb.com/docs/ch13.html to create and load your own partitioned schema. The best approach to partitioning TPC-H is to partition LINEITEM by date and there are a number of examples to do this. |
Beta Was this translation helpful? Give feedback.
-
Hi Steve, Thank you very much for your quick response. Best Regards, |
Beta Was this translation helpful? Give feedback.
That is correct, for now HammerDB does not partition the TPC-H schema for any database. This is because initially with the commerical databases partitioning is a paid option and not necessarily supported in all environments, therefore HammerDB built a schema that didn't rely on additional options. Also the open source databases didn't support analytic features such as column store or partitioning.
Therefore for now the way to partition the schema is to use the datagen option https://www.hammerdb.com/docs/ch13.html to create and load your own partitioned schema. The best approach to partitioning TPC-H is to partition LINEITEM by date and there are a number of examples to do this.
Now Postg…