From: msmbarabino@virgilio.it <msmbarabino@virgilio.it>
To: pgsql-performance@postgresql.org
Subject: Very slow bytea data extraction
Date: Fri, 23 Feb 2007 11:10:13 +0100 (GMT+01:00)
Message-ID: <110ee1452b5.msmbarabino@virgilio.it> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: msmbarabino@virgilio.it
Subject: Re: Very slow bytea data extraction
In-Reply-To: <110ee1452b5.msmbarabino@virgilio.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox