| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Sorin N(dot) Ciolofan" <ciolofan(at)ics(dot)forth(dot)gr> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] ERROR: out of shared memory |
| Date: | 2007-03-27 03:37:18 |
| Message-ID: | 11069.1174966638@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-performance |
"Sorin N. Ciolofan" <ciolofan(at)ics(dot)forth(dot)gr> writes:
> I have to manage an application written in java which call another module
> written in java which uses Postgre DBMS in a Linux environment. I'm new to
> Postgres. The problem is that for large amounts of data the application
> throws an:
> org.postgresql.util.PSQLException: ERROR: out of shared memory
AFAIK the only very likely way to cause that is to touch enough
different tables in one transaction that you run out of lock entries.
While you could postpone the problem by increasing the
max_locks_per_transaction setting, I suspect there may be some basic
application misdesign involved here. How many tables have you got?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-03-27 03:58:23 | Re: data from system tables. |
| Previous Message | Jim Nasby | 2007-03-26 22:10:05 | Re: autovacuum question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2007-03-27 04:10:09 | Re: How can I select a comment on a column? |
| Previous Message | Tom Lane | 2007-03-27 03:33:45 | Re: Every user has own database - how? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gauri Kanekar | 2007-03-27 10:43:31 | Re: Nested Loop |
| Previous Message | Ragnar | 2007-03-26 16:22:33 | Re: Nested Loop |