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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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