Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B24799FBC9F for ; Fri, 23 Feb 2007 06:10:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 21763-04 for ; Fri, 23 Feb 2007 06:10:19 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from vsmtp21.tin.it (vsmtp21.tin.it [212.216.176.109]) by postgresql.org (Postfix) with ESMTP id A4D8F9FB56B for ; Fri, 23 Feb 2007 06:10:19 -0400 (AST) Received: from cp3a.criticalpath.priv (192.168.70.91) by vsmtp21.tin.it (7.2.072.1) id 45D618B500B6C890 for pgsql-performance@postgresql.org; Fri, 23 Feb 2007 11:10:14 +0100 Received: from pswm6.cp.tin.it (192.168.70.26) by cp3a.criticalpath.priv (7.3.118.3) id 45D98EC4000779A9 for pgsql-performance@postgresql.org; Fri, 23 Feb 2007 11:11:29 +0100 Message-ID: <110ee1452b5.msmbarabino@virgilio.it> Date: Fri, 23 Feb 2007 11:10:13 +0100 (GMT+01:00) From: "msmbarabino@virgilio.it" Reply-To: "msmbarabino@virgilio.it" To: pgsql-performance@postgresql.org Subject: Very slow bytea data extraction Mime-Version: 1.0 Content-Type: text/plain;charset="UTF-8" Content-Transfer-Encoding: 7bit X-Originating-IP: 85.34.63.86 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.908 tagged_above=0 required=5 tests=BAYES_60, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST X-Spam-Level: ** X-Archive-Number: 200702/238 X-Sequence-Number: 23292 Hi all, I'm using Postgresql 8.2.3 on a Windows XP system. I need to write and retrieve bytea data from a table. The problem is that, while data insertion is quite fast, bytea extraction is very slow. I'm trying to store a 250KB image into the bytea field. A simple select query on a 36-row table takes more than one minute to execute. Any help would be very appreciated Thanks in advance Massimo