From: Pascal PEYRE <peyre@cir.fr>
To: pgsql-admin@postgresql.org
Subject: Vacuum Question
Date: Fri, 21 Feb 2003 08:48:58 +0100
Message-ID: <000001c2d97d$b11814c0$e3026b83@intranet.cir.fr> (raw)
Hi,
I use postgresql 7.2.x on Linux 2.4.18-6mdksmp #1 SMP i686
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.
For optimize my database I operate a vacuum "all" every night.
The problem is that the size of database is growing every day whereas
the volume of data stay remains stable. After six month my postgreSQL
databases size is approximately (40/50 Gb). Yesterday I suppress the
database and I restore it by pg_dump. By this way my database size is
gone down again to 4/5 Gb.
Is there any solution to reduce the size of the database without restore
a SQL backup ?
Thanks to your help
Pascal PEYRE
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: peyre@cir.fr
Subject: Re: Vacuum Question
In-Reply-To: <000001c2d97d$b11814c0$e3026b83@intranet.cir.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox