Betsy Barker <betsy(dot)barker(at)supportservicesinc(dot)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
In response to
pgsql-novice by date
|Next:||From: Betsy Barker||Date: 2004-09-13 15:16:58|
|Subject: LockAcquire: lock table 1 is out of memory|
|Previous:||From: Tom Lane||Date: 2004-09-13 14:28:52|
|Subject: Re: timestamp precision |