Re: Very slow bytea extraction

From: "msmbarabino(at)virgilio(dot)it" <msmbarabino(at)virgilio(dot)it>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Very slow bytea extraction
Date: 2007-03-27 08:52:24
Message-ID: 11192989288.msmbarabino@virgilio.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-bugs by date

  From Date Subject
Next Message Ivan Panchenko 2007-03-27 10:37:25 Old bug concerning regular expressions and UTF-8
Previous Message Zubkovsky, Sergey 2007-03-27 06:41:25 "Permission denied" failures occurring on Windows