From: | akp geek <akpgeek(at)gmail(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: WARNING: out of shared memory |
Date: | 2010-04-21 16:32:21 |
Message-ID: | v2i2024a9fb1004210932i444f89c1o7e8ca3058add2c03@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)hogranch(dot)com> 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)
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Watson, Nathaniel | 2010-04-21 17:05:35 | installation on vista |
Previous Message | John R Pierce | 2010-04-21 16:30:06 | Re: WARNING: out of shared memory |