Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 79514650109 for ; Wed, 27 Aug 2008 10:27:10 -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 58029-03-6 for ; Wed, 27 Aug 2008 10:26:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.sc.senai.br (mail.sc.senai.br [201.34.162.10]) by postgresql.org (Postfix) with ESMTP id 2754A6502F0 for ; Wed, 27 Aug 2008 10:24:59 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.sc.senai.br (Postfix) with ESMTP id B6B161848E; Wed, 27 Aug 2008 10:24:54 -0300 (BRT) X-Virus-Scanned: amavisd-new at mail.sc.senai.br Received: from mail.sc.senai.br ([127.0.0.1]) by localhost (mail.sc.senai.br [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id gF9bl4ZICRs3; Wed, 27 Aug 2008 10:24:51 -0300 (BRT) Received: from intranet.sc.senai.br (unknown [10.1.3.1]) by mail.sc.senai.br (Postfix) with ESMTP id 977BA18486; Wed, 27 Aug 2008 10:24:51 -0300 (BRT) Received: from phpmailer ([10.1.3.4]) by intranet.sc.senai.br with HTTP (PHPMailer); Wed, 27 Aug 2008 10:24:51 -0300 Date: Wed, 27 Aug 2008 10:24:51 -0300 To: Bill Moran , henk de wit Cc: "pgsql-performance@postgresql.org" From: DANIEL CRISTIAN CRUZ Subject: Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Message-ID: X-Priority: 3 X-Mailer: PHPMailer [version 1.71] X-Mailer: FeLaMiMail In-Reply-To: <20080827090123.c0e8e638.wmoran@collaborativefusion.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" 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/348 X-Sequence-Number: 31229 Maybe strace could help you find the problem, but could cause a great overhead... "Bill Moran" escreveu: > ... -- Daniel Cristian Cruz Administrador de Banco de Dados Dire=E7=E3o Regional=A0- N=FAcleo de Tecnologia da Informa=E7=E3o SENAI - SC Telefone: 48-3239-1422 (ramal 1422)