R: Very slow bytea data extraction - Mailing list 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