Re: Assistance with an out of shared memory error

From: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Assistance with an out of shared memory error
Date: 2022-01-16 00:15:18
Message-ID: 434dde00-59d2-64c1-ebf0-bc2b8765b337@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mladen Gogala 2022-01-16 00:23:04 Re: WAL Archiving and base backup
Previous Message Ron 2022-01-15 22:41:55 Re: WAL Archiving and base backup