Greetings, * Job (j...@colliniconsulting.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
signature.asc
Description: Digital signature
