Re: Very slow bytea data extraction - Mailing list pgsql-performance

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


pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Recommended Initial Settings
Next
From: "msmbarabino@virgilio.it"
Date:
Subject: Re: Very slow bytea data extraction