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

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 (view raw or flat)
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

pgsql-bugs by date

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

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