>Well, that eliminates the theory that you've got a lot of dead
>slowing it down. I come back to the conclusion that it's
>client-side problem. Have you tried watching with "top" or
>to check which process is eating all the time?
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
pgsql-bugs by date
|Next:||From: TANIDA Yutaka||Date: 2007-03-23 01:33:45|
|Subject: Re: "Relation not found" error but table exits.|
|Previous:||From: Tom Lane||Date: 2007-03-22 20:23:16|
|Subject: Re: Very slow bytea extraction |