[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
