Postgres Pro
Downloads
Home   >   mailing lists

Re: increasing of the shared memory does not solve the problem of "OUT of shared memory" - Mailing list pgsql-admin

From Adam Tauno Williams
Subject Re: increasing of the shared memory does not solve the problem of "OUT of shared memory"
Date
Msg-id 1178908897.4331.63.camel@aleph.whitemice.org
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>)
Responses Re: increasing of the shared memory does not solve theproblem of "OUT of shared memory"  ("Sorin N. Ciolofan" <ciolofan@ics.forth.gr>)
List pgsql-admin
Tree view 

> I increased significantly the number of shared buffers from 3000 to
> 100 000 (80Mb)
> 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
> Is this message appropriate to the real cause of the problem or the
> reason of the failure is actually other than what is displayed in this
> message?
>
Maybe you've got an application that is doing a BEGIN WORK, but never
doing a rollback or commit?
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org

pgsql-admin by date:

Previous
From: "Sorin N. Ciolofan"
Date:
Subject: increasing of the shared memory does not solve the problem of "OUT of shared memory"
Next
From: Tom Lane
Date:
Subject: Re: increasing of the shared memory does not solve the problem of "OUT of shared memory"