| From: | Adam Tauno Williams <adamtaunowilliams(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: increasing of the shared memory does not solve the problem of "OUT of shared memory" |
| Date: | 2007-05-11 18:41:37 |
| Message-ID: | 1178908897.4331.63.camel@aleph.whitemice.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-05-11 20:26:10 | Re: increasing of the shared memory does not solve the problem of "OUT of shared memory" |
| Previous Message | Sorin N. Ciolofan | 2007-05-11 13:58:28 | increasing of the shared memory does not solve the problem of "OUT of shared memory" |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoffrey | 2007-05-11 18:55:53 | Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array) |
| Previous Message | Ottavio Campana | 2007-05-11 18:22:37 | Re: tokenize string for tsearch? |