Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum in pg9beta4 much slower than in 8.4 - Mailing list pgsql-testers

From Josh Berkus
Subject Re: vacuum in pg9beta4 much slower than in 8.4
Date
Msg-id 4C697179.5080906@agliodbs.com
Whole thread Raw
In response to Re: vacuum in pg9beta4 much slower than in 8.4  (Mario Splivalo <mario.splivalo@megafon.hr>)
List pgsql-testers
Tree view 
> Yes, I run the tests on clean tables. I run VACUUM FULL, and after that
> I mesured how long it takes for VACUUM ANALYZE and VACUUM ANALYZE FULL.
> So, it is ok for VACUUM FULL (on clean tables) on 9.0b4 to be six times
> slower than on 8.4. But is it ok for plain VACUUM to be two times slower?

On clean or on dirty tables?

--
                                   -- Josh Berkus
                                      PostgreSQL Experts Inc.
                                      http://www.pgexperts.com

pgsql-testers by date:

Previous
From: Mario Splivalo
Date:
Subject: Re: vacuum in pg9beta4 much slower than in 8.4
Next
From: Jai Soni
Date:
Subject: feature request in postgresql 9.0 release