Greetings,
* Job (Job(at)colliniconsulting(dot)it) wrote:
> we have a test machine with Postgresql 9.6.1 an about 800.000.000 record in a table.
> Table is partitioned by day, with indexes on partitioned table.
You probably shouldn't be partitioning by day for such a small dataset,
unless you've only got a few days worth of data that make up those 800m
records.
Having hundreds of partitions leads to slow query planning time. There
is work happening to improve on this by having declarative partitions
instead of using CHECK constraints and the constrain exclusion
mechanism.
Thanks!
Stephen