Re: Assistance with an out of shared memory error

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