Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E81319FC1A2 for ; Fri, 23 Feb 2007 08:20:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 31945-08 for ; Fri, 23 Feb 2007 08:19:54 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from smtp1web.tin.it (smtp1web.tin.it [212.216.176.195]) by postgresql.org (Postfix) with ESMTP id 719A89FB718 for ; Fri, 23 Feb 2007 08:19:58 -0400 (AST) Received: from cp3a.criticalpath.priv (192.168.70.91) by smtp1web.tin.it (7.2.072.1) id 45D1E5A80021B83F for pgsql-performance@postgresql.org; Fri, 23 Feb 2007 13:19:56 +0100 Received: from pswm13.cp.tin.it (192.168.70.37) by cp3a.criticalpath.priv (7.3.118.3) id 45D98EC40007CCA1 for pgsql-performance@postgresql.org; Fri, 23 Feb 2007 13:21:12 +0100 Message-ID: <110ee8b13e5.msmbarabino@virgilio.it> Date: Fri, 23 Feb 2007 13:19:56 +0100 (GMT+01:00) From: "msmbarabino@virgilio.it" Reply-To: "msmbarabino@virgilio.it" To: pgsql-performance@postgresql.org Subject: R: Very slow bytea data extraction Mime-Version: 1.0 Content-Type: text/plain;charset="UTF-8" Content-Transfer-Encoding: 7bit X-Originating-IP: 151.64.149.238 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.732 tagged_above=0 required=5 tests=AWL, BAYES_50, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST X-Spam-Level: * X-Archive-Number: 200702/240 X-Sequence-Number: 23294 Thanks for your reply, >Is it in executing the query (what does EXPLAIN ANALYSE show)? Here is the output of explain analyze SELECT * FROM "FILE" "Seq Scan on "FILE" (cost=0.00..1.36 rows=36 width=235) (actual time=0.023..0.107 rows=36 loops=1)" >How are you accessing the database: odbc,jdbc,other? >Does it do this with psql too? The problem is the same when I access the db with jdbc, pgAdmin and even psql Massimo