Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory - Mailing list pgsql-general

From Adrian Klaver
Subject Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory
Date
Msg-id c027668d-16c1-736c-585f-d9cc100a1e12@aklaver.com
Whole thread Raw
In response to Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
Tree view 
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.klaver@aklaver.com

pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory
Next
From: Alvaro Herrera
Date:
Subject: Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory