Skip site navigation (1) Skip section navigation (2)

Re: Very slow bytea data extraction

From: "msmbarabino(at)virgilio(dot)it" <msmbarabino(at)virgilio(dot)it>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Very slow bytea data extraction
Date: 2007-02-23 17:44:27
Message-ID: 110efb42d61.msmbarabino@virgilio.it (view raw or flat)
Thread:
Lists: 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


Responses

pgsql-performance by date

Next:From: msmbarabino@virgilio.itDate: 2007-02-23 17:55:20
Subject: Re: Very slow bytea data extraction
Previous:From: Jim C. NasbyDate: 2007-02-23 17:43:56
Subject: Re: Recommended Initial Settings

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group