Postgres Pro
Downloads
Home   >   mailing lists

Re: LockAcquire: lock table 1 is out of memory - Mailing list pgsql-novice

From Tom Lane
Subject Re: LockAcquire: lock table 1 is out of memory
Date
Msg-id 9733.1095086875@sss.pgh.pa.us
Whole thread Raw
In response to LockAcquire: lock table 1 is out of memory  (Betsy Barker <betsy.barker@supportservicesinc.com>)
Responses Re: LockAcquire: lock table 1 is out of memory
List pgsql-novice
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: timestamp precision
Next
From: A Gilmore
Date:
Subject: Re: timestamp precision