>If you look at the "actual time" it's completing very quickly indeed.
>- it must be something to do with either:
>>2. Transferring the data to the client.
I do agree.
happens if you only select half the rows? Does the time to run the
Yes, it does.
Using pgAdmin, the time to get all 36
rows is about 67500ms while it's 24235ms to get only 18 rows.
pgsql-performance by date
|Next:||From: firstname.lastname@example.org||Date: 2007-02-23 17:55:20|
|Subject: Re: Very slow bytea data extraction|
|Previous:||From: Jim C. Nasby||Date: 2007-02-23 17:43:56|
|Subject: Re: Recommended Initial Settings|