From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
Cc: | 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 17:39:26 |
Message-ID: | 2208869.1641836366@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dominique Devienne <ddevienne(at)gmail(dot)com> writes:
> I'm trying to DROP a ROLE that has 4 schemas:
> * 2 smallish ones (1 or 2 dozen tables each),
> * 2 largish ones (250 tables, totalling around 4000 columns each).
> And of course there are various indexes, constraints, etc... on each schema.
You're going to need a lock per dropped relation. The number of
columns or rows doesn't enter into it, but the number of indexes does.
> DDL Error: DROP OWNED BY "Epos-PNS (a73e1fbdcc5b4460ba55703a0d6b6ad7)"
> CASCADE: #53200: ERROR: out of shared memory
> HINT: You might need to increase max_locks_per_transaction.
I'd not have expected that when dropping 500-or-so tables, but maybe
you have a lot of indexes per table?
> And please note that there could be dozens even hundreds of largish schemas
> associated to the dropped ROLE (2 + N), not just the 2+2 it fails with here.
There's not a lot of penalty to increasing max_locks_per_transaction,
but no you can't make it "unbounded".
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Dominique Devienne | 2022-01-10 19:12:14 | Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory |
Previous Message | Dominique Devienne | 2022-01-10 17:26:52 | DROP OWNED BY fails with #53200: ERROR: out of shared memory |