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