Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] increasing of the shared memory does not solve the problem of "OUT of shared memory" - Mailing list pgsql-general

From Tom Lane
Subject Re: [ADMIN] increasing of the shared memory does not solve the problem of "OUT of shared memory"
Date
Msg-id 2873.1178915170@sss.pgh.pa.us
Whole thread Raw
In response to increasing of the shared memory does not solve the problem of "OUT of shared memory"  ("Sorin N. Ciolofan" <ciolofan@ics.forth.gr>)
List pgsql-general
Tree view 
"Sorin N. Ciolofan" <ciolofan@ics.forth.gr> writes:
> Also I increased the max_locks_per_transaction from  64  to 10 000.

> I still receive the same error form Postgres:
> org.postgresql.util.PSQLException: ERROR: out of shared memory

Did you remember to restart the postmaster after doing that?  (pg_ctl
reload isn't good enough, you need an actual restart to enlarge shared
memory.)  You can confirm whether it's really taken effect with
"show max_locks_per_transaction".

            regards, tom lane

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)
Next
From: "Dhaval Shah"
Date:
Subject: Streaming large data into postgres [WORM like applications]