From: Richard Huxton <dev@archonet.com>
To: msmbarabino@virgilio.it <msmbarabino@virgilio.it>
Cc: pgsql-performance@postgresql.org
Subject: Re: Very slow bytea data extraction
Date: Fri, 23 Feb 2007 10:46:14 +0000
Message-ID: <45DEC5F6.4000101@archonet.com> (raw)
In-Reply-To: <110ee1452b5.msmbarabino@virgilio.it>
References: <110ee1452b5.msmbarabino@virgilio.it>
msmbarabino@virgilio.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
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: dev@archonet.com, msmbarabino@virgilio.it
Subject: Re: Very slow bytea data extraction
In-Reply-To: <45DEC5F6.4000101@archonet.com>
* 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