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

db size and VACUUM ANALYZE

From: Marcin Krol <mrkafk(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: db size and VACUUM ANALYZE
Date: 2010-02-12 17:09:54
Message-ID: 4B758B62.6090109@gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello,

The db in the application I maintain but didn't write (it obviously 
makes use of PG, v 8.3), has been systematically growing in size from 
about 600M to 1.6G.

At the same time, the performance of the app has degraded significantly 
(several times).

So I've done VACUUM ANALYZE on entire db. Nothing. The db did not 
decrease in size, the performance stayed the same.

So I backed it up using pg_dump, deleted database, and recreated it from 
backup.

The size of db on disk went down to 600M, performance recovered to the 
original level.

Why that is so? I thought that VACUUM ANALYZE does everything that is 
needed to optimize disk usage?

Regards,
mk

Responses

pgsql-novice by date

Next:From: Brad NicholsonDate: 2010-02-12 17:18:33
Subject: Re: db size and VACUUM ANALYZE
Previous:From: u235sentinelDate: 2010-02-11 19:36:26
Subject: Re: Postgres Triggers issue

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