Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Dominique Devienne <ddevienne(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory
Date: 2022-01-10 19:24:33
Message-ID: c027668d-16c1-736c-585f-d9cc100a1e12@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/10/22 11:12, Dominique Devienne wrote:
> I accidentally replied to Tom only. Here's my response again.
>
> Apparently, I'm using the default max_locks_per_transaction:
> ```
> ddevienne=> show max_locks_per_transaction ;
>  max_locks_per_transaction
> ---------------------------
>  64
> (1 row)
> ```
>

>
> Tom wrote "relation" for the number of locks necessary for DROP OWNED BY.
> What does it mean in this context? relation = table?

https://www.postgresql.org/docs/14/glossary.html#GLOSSARY-RELATION

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2022-01-10 19:48:40 Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory
Previous Message Dominique Devienne 2022-01-10 19:12:14 Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory