Re: Very slow bytea extraction

>
>No,
>actually I haven't yet.
>I have noticed that during the time
the query
>executes there is neither so much CPU load nor network
(communication
>with db) load. The client seems to hang, then after a
minute or so the
>query returns data.
>I also thought this problem
could be related to db
>encoding but changing it didn't help at all.
>If it's a client-related
>problem, I can't understand why such
different clients behave the same
>way


Checking Windows Task
Manager, after the query has been submitted, none of the postgresql
processes or client processes seems to be using CPU. The only process
that uses CPU is the System Idle Process (98 % CPU usage).
Both client
and server seem to be doing nothing.

Regards

Massimo