Re: Very slow bytea data extraction

msmbarabino(at)virgilio(dot)it wrote:
>> 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.

Hmm - I've seen reports about the traffic-shaping module not being
install/activated making large data transfers slow. That was on Windows
2000 though. Might be worth searching the mail archives - I'm afraid I
run PG on Linux mostly, so can't say for sure.

One other thing I'd test. Make a small table with text columns of the
same size and see how fast it is to select from that. If it's just as
slow then it's your network setup. If it's much faster then it's
something to do with the bytea type.

--
Richard Huxton
Archonet Ltd