Re: [PERFORM] vacuum in Postgresql 8.0.x slowing down the database

2008-03-27 Thread Vinubalaji Gopal
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

Re: [PERFORM] vacuum in Postgresql 8.0.x slowing down the database

2008-03-26 Thread Joshua D. Drake
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