Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Very slow bytea extraction
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "msmbarabino(at)virgilio(dot)it" <msmbarabino(at)virgilio(dot)it>
- Cc: pgsql-bugs(at)postgresql(dot)org
- Subject: Re: Very slow bytea extraction
- Date: Thu, 22 Mar 2007 16:23:16 -0400
"msmbarabino(at)virgilio(dot)it" <msmbarabino(at)virgilio(dot)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
- References:
- Re: Very slow bytea extraction
- From: msmbarabino(at)virgilio(dot)it
- Re: Very slow bytea extraction
- Prev by Date: Re: "Relation not found" error but table exits.
- Next by Date: Re: Very slow bytea extraction
- Previous by thread: Re: Very slow bytea extraction
- Next by thread: Re: Very slow bytea extraction
- Indexes: