Re: Very slow bytea data extraction

msmbarabino(at)virgilio(dot)it wrote:
> Hi all,
> I'm using Postgresql 8.2.3 on a Windows XP system.
>
> I need to
> write and retrieve bytea data from a table.
> The problem is that, while
> data insertion is quite fast, bytea extraction is very slow.
> I'm trying
> to store a 250KB image into the bytea field.
> A simple select query on a
> 36-row table takes more than one minute to execute.

Where is the problem?

Is it in executing the query (what does EXPLAIN ANALYSE show)?
Is it in fetching/formatting the data (what does the equivalent COUNT(*)
show)?
How are you accessing the database: odbc,jdbc,other?
Does it do this with psql too?

--
Richard Huxton
Archonet Ltd