Skip site navigation (1) Skip section navigation (2)

Re: LockAcquire: lock table 1 is out of memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Betsy Barker <betsy(dot)barker(at)supportservicesinc(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: LockAcquire: lock table 1 is out of memory
Date: 2004-09-13 14:47:55
Message-ID: 9733.1095086875@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Betsy BarkerDate: 2004-09-13 15:16:58
Subject: LockAcquire: lock table 1 is out of memory
Previous:From: Tom LaneDate: 2004-09-13 14:28:52
Subject: Re: timestamp precision

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group