Re: WARNING: out of shared memory

[akp geek <akpgeek@xxxxxxxxx>]

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 <pierce@xxxxxxxxxxxx> 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)