Re: LockAcquire: lock table 1 is out of memory

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: LockAcquire: lock table 1 is out of memory
Дата
Msg-id 9733.1095086875@sss.pgh.pa.us
обсуждение исходный текст
Ответ на LockAcquire: lock table 1 is out of memory  (Betsy Barker <betsy.barker@supportservicesinc.com>)
Ответы Re: LockAcquire: lock table 1 is out of memory  (Betsy Barker <betsy.barker@supportservicesinc.com>)
Список pgsql-novice
Betsy Barker <betsy.barker@supportservicesinc.com> writes:
> I am getting the following error while running a series of stored procedures. I have increased the
max_locks_per_transaction
> parameter from 64 (the default) to 128 and I still received this
> error. Can anyone tell me waht else I could do?

Raise it further ...

Note also that you need a postmaster restart (not just SIGHUP) to make
the increase take effect.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: timestamp precision
Следующее
От: A Gilmore
Дата:
Сообщение: Re: timestamp precision