On Wed, 26 Mar 2008 13:02:13 -0700
"Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> The slowness is likely attributed to Vacuum's use of I/O. When vacuum
> is running what does iostat -k 10 say?
Seems to be higher than normal - here is the output with vacuum run
without the other queries and the d
On Wed, 26 Mar 2008 12:49:56 -0800
Vinubalaji Gopal <[EMAIL PROTECTED]> wrote:
> The big table has never been reindexed and has a primary, unique key
> with btree index and one foreign key constraint.
The slowness is likely attributed to Vacuum's use of I/O. When vacuum
is running what does iosta