akp geek wrote:
Hi All -
I have been trying to drop 2000 tables using a script.
I am getting the following error message. I have the value set
for max_locks_per_transaction = 100 . Error message is as follows
WARNING: out of shared memory
ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
********** Error **********
ERROR: out of shared memory
SQL state: 53200
Hint: You might need to increase max_locks_per_transaction.
is your script bracketed by BEGIN; ..... COMMIT; ?
if so, you might consider breaking it up into smaller chunks, like
BEGIN; (drop about 50 tables); COMMIT; (repeat)
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
