Postgres Pro
Downloads
Home   >   mailing lists

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

From Betsy Barker
Subject LockAcquire: lock table 1 is out of memory
Date
Msg-id 20040913091658.49270015.betsy.barker@supportservicesinc.com
Whole thread Raw
Responses Re: LockAcquire: lock table 1 is out of memory
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: create table error
Next
From: Tom Lane
Date:
Subject: Re: timestamp precision