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

From Tom Lane
Subject Re: Very slow bytea extraction
Date
Msg-id 26521.1174594996@sss.pgh.pa.us
Whole thread Raw
In response to Re: Very slow bytea extraction  ("msmbarabino@virgilio.it" <msmbarabino@virgilio.it>)
List pgsql-bugs
"msmbarabino@virgilio.it" <msmbarabino@virgilio.it> writes:
>> Hmm ... what does VACUUM VERBOSE of that table show?

> Here is the
> output of VACUUM VERBOSE

Well, that eliminates the theory that you've got a lot of dead tuples
slowing it down.  I come back to the conclusion that it's probably a
client-side problem.  Have you tried watching with "top" or similar tool
to check which process is eating all the time?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Relation not found" error but table exits.
Next
From: "msmbarabino@virgilio.it"
Date:
Subject: Re: Very slow bytea extraction