Re: Very slow bytea extraction - Mailing list pgsql-bugs

From msmbarabino@virgilio.it
Subject Re: Very slow bytea extraction
Date
Msg-id 11192989288.msmbarabino@virgilio.it
Whole thread Raw
In response to Very slow bytea extraction  ("msmbarabino@virgilio.it" <msmbarabino@virgilio.it>)
List pgsql-bugs
>
>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

pgsql-bugs by date:

Previous
From: "Zubkovsky, Sergey"
Date:
Subject: "Permission denied" failures occurring on Windows
Next
From: "Guillaume Smet"
Date:
Subject: Partial index on varchar fields with IN