Very slow bytea data extraction - Mailing list pgsql-performance

From msmbarabino@virgilio.it
Subject Very slow bytea data extraction
Date
Msg-id 110ee1452b5.msmbarabino@virgilio.it
Whole thread Raw
Responses Re: Very slow bytea data extraction  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
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.

Any help would be
very appreciated

Thanks in advance

Massimo


pgsql-performance by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Using the 8.2 autovacuum values with 8.1
Next
From: Richard Huxton
Date:
Subject: Re: Very slow bytea data extraction