Betsy Barker <betsy.barker (AT) supportservicesinc (DOT) com> writes:
Raise it further ...

Note also that you need a postmaster restart (not just SIGHUP) to make
the increase take effect.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

I raised the parameter to 256 and the process finished. Thank you Tom. Does raising that parameter cause the database to slow 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 again could have caused the problem in the beginning?

Thank you,
Betsy Barker

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


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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html