Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 638C564FD34 for ; Wed, 27 Aug 2008 04:21:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 15029-08 for ; Wed, 27 Aug 2008 04:21:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx01.bfk.de (mx01.bfk.de [193.227.124.2]) by postgresql.org (Postfix) with ESMTP id B724264FD13 for ; Wed, 27 Aug 2008 04:21:40 -0300 (ADT) Received: from mx00.int.bfk.de ([10.119.110.2]) by mx01.bfk.de with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) id 1KYFLM-0008Nq-J8; Wed, 27 Aug 2008 09:21:28 +0200 Received: from fweimer by bfk.de with local id 1KYFLU-0004bI-6o; Wed, 27 Aug 2008 09:21:36 +0200 To: henk de wit Cc: Subject: Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception References: From: Florian Weimer Date: Wed, 27 Aug 2008 09:21:35 +0200 In-Reply-To: (henk de wit's message of "Tue, 26 Aug 2008 18:44:02 +0200") Message-ID: <82bpze3ou8.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/344 X-Sequence-Number: 31225 * henk de wit: > On this table we're inserting records with a relatively low > frequency of +- 6~10 per second. We're using PG 8.3.1 on a machine > with two dual core 2.4Ghz XEON CPUs, 16 GB of memory and Debian > Linux. The machine is completely devoted to PG, nothing else runs on > the box. Have you disabled the OOM killer? --=20 Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstra=DFe 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99