Re: [ADMIN] increasing of the shared memory does not solve the problem of "OUT of shared memory"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [ADMIN] increasing of the shared memory does not solve the problem of "OUT of shared memory"
Дата
Msg-id 2873.1178915170@sss.pgh.pa.us
обсуждение исходный текст
Ответ на increasing of the shared memory does not solve the problem of "OUT of shared memory"  ("Sorin N. Ciolofan" <ciolofan@ics.forth.gr>)
Список pgsql-general
Дерево обсуждения 
"Sorin N. Ciolofan" <ciolofan@ics.forth.gr> writes:
> Also I increased the max_locks_per_transaction from  64  to 10 000.

> I still receive the same error form Postgres:
> org.postgresql.util.PSQLException: ERROR: out of shared memory

Did you remember to restart the postmaster after doing that?  (pg_ctl
reload isn't good enough, you need an actual restart to enlarge shared
memory.)  You can confirm whether it's really taken effect with
"show max_locks_per_transaction".

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)
Следующее
От: "Dhaval Shah"
Дата:
Сообщение: Streaming large data into postgres [WORM like applications]