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: 4C6801B4.5050202@megafon.hr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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?

Mike

Responses

Browse pgsql-testers by date

  From Date Subject
Next Message Mario Splivalo 2010-08-15 18:22:10 pg_upgrade test
Previous Message Krzysztof Hoffmann 2010-08-11 12:38:20