Re: Vacuum Question - Mailing list pgsql-admin

From Tom Lane
Subject Re: Vacuum Question
Date
Msg-id 2168.1045881672@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum Question  ("Pascal PEYRE" <peyre@cir.fr>)
List pgsql-admin
"Pascal PEYRE" <peyre@cir.fr> writes:
> I have some big postgreSQL databases (4/5 GB at start) on this server.
> Every night I erase data and I import a lot of new data.

Exactly how do you erase the old data?  If you're zapping the entire
contents of tables, TRUNCATE might be a good answer.

> For optimize my database I operate a vacuum "all" every night.

Plain vacuum, or vacuum full?  If it's a plain vacuum, do you have the
free space map parameters (in postgresql.conf) set large enough to cover
your database?

> The problem is that the size of database is growing every day whereas
> the volume of data stay remains stable.

Exactly which tables are bloating?  Look at the relpages column of
pg_class (just after a vacuum, so that the values are up to date).
Look to see which entries grow from day to day...

            regards, tom lane

pgsql-admin by date:

Previous
From: Artur Pietruk
Date:
Subject: Re: problem: Postgresql and Unicode
Next
From: "Nathalie Boulos"
Date:
Subject: Re: problem: Postgresql and Unicode