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
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 |