From: msmbarabino@virgilio.it <msmbarabino@virgilio.it>
To: pgsql-performance@postgresql.org
Subject: Re: Very slow bytea data extraction
Date: Fri, 23 Feb 2007 18:44:27 +0100 (GMT+01:00)
Message-ID: <110efb42d61.msmbarabino@virgilio.it> (raw)
>If you look at the "actual time" it's completing very quickly indeed.
So
>- it must be something to do with either:
>1. Fetching/formatting
the data
>>2. Transferring the data to the client.
I do agree.
>What
happens if you only select half the rows? Does the time to run the
>select halve?
Yes, it does.
Using pgAdmin, the time to get all 36
rows is about 67500ms while it's 24235ms to get only 18 rows.
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: <110efb42d61.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