Skip site navigation (1) Skip section navigation (2)

R: Very slow bytea data extraction

From: "msmbarabino(at)virgilio(dot)it" <msmbarabino(at)virgilio(dot)it>
To: pgsql-performance(at)postgresql(dot)org
Subject: R: Very slow bytea data extraction
Date: 2007-02-23 12:19:56
Message-ID: 110ee8b13e5.msmbarabino@virgilio.it (view raw or flat)
Thread:
Lists: pgsql-performance
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


Responses

pgsql-performance by date

Next:From: Richard HuxtonDate: 2007-02-23 14:39:21
Subject: Re: R: Very slow bytea data extraction
Previous:From: Richard HuxtonDate: 2007-02-23 10:46:14
Subject: Re: Very slow bytea data extraction

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group