Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 8D7CB9FC272; Fri, 11 May 2007 10:57:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 40813-05; Fri, 11 May 2007 10:57:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mailhost.ics.forth.gr (mailhost.ics.forth.gr [139.91.157.55]) by postgresql.org (Postfix) with ESMTP id A31129FC26D; Fri, 11 May 2007 10:57:32 -0300 (ADT) Received: from mailhost.ics.forth.gr (mailhost.ics.forth.gr [139.91.157.55] (may be forged)) by mailhost.ics.forth.gr (8.13.8/ICS-FORTH/V10-Server-2.0.0) with ESMTP id l4BDvUQt002097; Fri, 11 May 2007 16:57:30 +0300 Received: from sappho.ics.forth.gr (unknown [127.0.0.1]) by mailhost.ics.forth.gr (Symantec Mail Security) with ESMTP id 0700B16C061; Fri, 11 May 2007 16:57:30 +0300 (EEST) X-AuditID: 7f000001-a2f23bb000003e42-9e-46447648e1de Received: from SHADOWFAX (unknown [139.91.183.33]) by mailhost.ics.forth.gr (Symantec Mail Security) with ESMTP id ECEDB8E40FC; Fri, 11 May 2007 16:57:27 +0300 (EEST) From: "Sorin N. Ciolofan" To: , Subject: increasing of the shared memory does not solve the problem of "OUT of shared memory" Date: Fri, 11 May 2007 16:58:28 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0040_01C793ED.990BAD40" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 thread-index: AceT1HORybHIbS0oRzqzVB7p3rbooA== Message-Id: <20070511135727.ECEDB8E40FC@mailhost.ics.forth.gr> X-Brightmail-Tracker: AAAAAA== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/95 X-Sequence-Number: 25415 This is a multi-part message in MIME format. ------=_NextPart_000_0040_01C793ED.990BAD40 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello! 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? With best regards, Sorin N. Ciolofan ------=_NextPart_000_0040_01C793ED.990BAD40 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

 

Hello!

 

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?

 

With best regards,

Sorin N. Ciolofan

 

 

------=_NextPart_000_0040_01C793ED.990BAD40--