Обсуждение: LockAcquire: lock table 1 is out of memory

Hello,
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?

Thank you!

WARNING:  ShmemAlloc: out of memory
WARNING:  Error occurred while executing PL/pgSQL function get_facility_percentiles
WARNING:  line 37 at execute statement
ERROR:  LockAcquire: lock table 1 is out of memory

--
Betsy Barker
IT Manager
Support Services, Inc
(720)489-1630 X 38

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

I raised the parameter to 256 and the process finished. Thank you Tom. Does raising that parameter cause the database
toslow down? The process ended up taking 14.5 hours to finish! That seems like a long long time.  

Also, do you think that the use of a temporary table inside an inner loop, being created and dropped over and over
againcould have caused the problem in the beginning? 

Thank you,
Betsy Barker

On Mon, 13 Sep 2004 10:47:55 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> 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
>


--
Betsy Barker
IT Manager
Support Services, Inc
(720)489-1630 X 38

Once I subcribed this mail group but I wish to unsubscribe now.
Can anyone help me by unsubscribing me or tell me how I can do it.

Thanks for your help.

Burçin