Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 14C999FC308 for ; Fri, 23 Feb 2007 12:35:53 -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 85160-04-4 for ; Fri, 23 Feb 2007 12:35:44 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id D79C49FC350 for ; Fri, 23 Feb 2007 12:35:43 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so359584ugf for ; Fri, 23 Feb 2007 08:35:43 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=AWtrxp22KK6TA1NjXttXho5zJK9PYdIVrjQIliiM+ejQPgcZZXt8+Y/c/YWjP97eSL2ndV+FH3AOrsj+pjG1/fxMSERat2uofBWZ1gwyAJczxHsRxItf9wY4/DjThWRShREiUcZRwKC7Xf+MxhiLNSkhuVDfAVmupdeidVALhnc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=eATuN9URzmT46dsH3cLPigsjWmIZfFw4zpFGsV32/pJ6mQ1A8L8mqKhjanpORGWvJKYm6Z8U993optIsV8Lk5b99QdufsTqKam3SE61UklRxp7ryJGwXuMPLZ+WyY7Bffe5AaWZThxX8A1n2ZZVAQnjNVijACxFpI6+a6hGWVd8= Received: by 10.78.193.19 with SMTP id q19mr193035huf.1172248542365; Fri, 23 Feb 2007 08:35:42 -0800 (PST) Received: by 10.78.35.18 with HTTP; Fri, 23 Feb 2007 08:35:42 -0800 (PST) Message-ID: Date: Fri, 23 Feb 2007 11:35:42 -0500 From: "Merlin Moncure" To: "msmbarabino@virgilio.it" Subject: Re: R: Very slow bytea data extraction Cc: pgsql-performance@postgresql.org In-Reply-To: <110ee8b13e5.msmbarabino@virgilio.it> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <110ee8b13e5.msmbarabino@virgilio.it> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/244 X-Sequence-Number: 23298 On 2/23/07, msmbarabino@virgilio.it wrote: > 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 are you getting the data from the local box or from a remote site? also explain analyze is showing nothing slow but you did not post the enitre output. also, try the \timing switch in psql. merlin