Re: [GENERAL] WARNING: out of shared memory
That's what I did. I did it for every 500 tables . 4 chunks.. It worked Regards On Wed, Apr 21, 2010 at 12:30 PM, John R Pierce wrote: > 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) > > >
Re: [GENERAL] WARNING: out of shared memory
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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] WARNING: out of shared memory
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. appreciate your help regards