Very slow bytea data extraction

From: "msmbarabino(at)virgilio(dot)it" <msmbarabino(at)virgilio(dot)it>
To: pgsql-performance(at)postgresql(dot)org
Subject: Very slow bytea data extraction
Date: 2007-02-23 10:10:13
Message-ID: 110ee1452b5.msmbarabino@virgilio.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2007-02-23 10:46:14 Re: Very slow bytea data extraction
Previous Message Csaba Nagy 2007-02-23 09:13:31 Re: Using the 8.2 autovacuum values with 8.1