Skip site navigation (1) Skip section navigation (2)

vacuum in pg9beta4 much slower than in 8.4

From: Mario Splivalo <mario(dot)splivalo(at)megafon(dot)hr>
To: pgsql-testers(at)postgresql(dot)org
Subject: vacuum in pg9beta4 much slower than in 8.4
Date: 2010-08-15 15:03:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-testers
I think this is ok, but I'd just like a confirmation.

I have a db cluster with 6 databases, totaling around 6 GB of data.

In postgres 8.4 subsequent runs of 'vacuumdb -afvz' takes around 55 
seconds (average from 10 runs). 'vacuumdb -avz' takes around 40 seconds 
(average from 10 runs).

However, in postgres 9.0beta4, 'vacuumdb -avz' takes around 2 minutes 
(average from 10 runs), and 'vacuumdb -afvz' takes around 12 minutes 
(average from 4 runs).

I understand that VACUUM FULL in 9.0 copies all the data, but is it OK 
that plain vacuum in 9.0 is slower than in 8.4?



pgsql-testers by date

Next:From: Mario SplivaloDate: 2010-08-15 18:22:10
Subject: pg_upgrade test
Previous:From: Krzysztof HoffmannDate: 2010-08-11 12:38:20

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group