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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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