On 1/13/22 18:35, Tom Lane wrote:
.. or else reduce the number of partitions you're using. (People frequently seem to think that more partitions are free. That is extremely not true. I generally think that if you're using more than a few dozen partitions per table, you are making a mistake.)
Interesting. What resources do partitions consume? Is it documented anywhere? Why do you think that more than a few dozen partitions is a mistake?
Thanks in advance for your explanation. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com
