Re: WARNING: out of shared memory
| От | akp geek |
|---|---|
| Тема | Re: WARNING: out of shared memory |
| Дата | |
| Msg-id | v2i2024a9fb1004210932i444f89c1o7e8ca3058add2c03@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: WARNING: out of shared memory (John R Pierce <pierce@hogranch.com>) |
| Список | 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@hogranch.com> wrote:
is your script bracketed by BEGIN; ..... COMMIT; ?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.
if so, you might consider breaking it up into smaller chunks, like BEGIN; (drop about 50 tables); COMMIT; (repeat)
В списке pgsql-general по дате отправления: