Betsy Barker <betsy(dot)barker(at)supportservicesinc(dot)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