Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql functions and transactions? - Mailing list pgsql-novice

From Tom Lane
Subject Re: pgsql functions and transactions?
Date
Msg-id 5564.1093576152@sss.pgh.pa.us
Whole thread Raw
In response to pgsql functions and transactions?  (Betsy Barker <betsy.barker@supportservicesinc.com>)
Responses Re: pgsql functions and transactions?
List pgsql-novice
Tree view 
Betsy Barker <betsy.barker@supportservicesinc.com> writes:
> 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

Hmm, are you touching a whole lot of different tables in one
transaction?  If so you may need to raise the max_locks_per_transaction
parameter.

If that doesn't help, we need more details about what you're doing.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Luiz K. Matsumura"
Date:
Subject: Re: DISTINCT ordering
Next
From: Josh Berkus
Date:
Subject: Re: pgsql functions and transactions?