X-Original-To: pgsql-admin@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B0FD0474E4F for ; Fri, 21 Feb 2003 02:52:38 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 38253-10 for ; Fri, 21 Feb 2003 02:52:27 -0500 (EST) Received: from smtp2.extranet.oleane.net (smtp2.extranet.oleane.net [195.25.31.191]) by postgresql.org (Postfix) with ESMTP id 9981A475843 for ; Fri, 21 Feb 2003 02:52:27 -0500 (EST) Received: from mail.intranet.cir.fr (unknown [194.2.206.66]) by smtp2.extranet.oleane.net (Postfix) with SMTP id 763981FA40 for ; Fri, 21 Feb 2003 08:50:11 +0100 (CET) Received: (qmail 2511 invoked from network); 21 Feb 2003 06:42:20 -0000 Received: from unknown (HELO sillage) (131.107.2.227) by mail.intranet.cir.fr with SMTP; 21 Feb 2003 06:42:20 -0000 From: "Pascal PEYRE" To: Subject: Vacuum Question Date: Fri, 21 Feb 2003 08:48:58 +0100 Message-ID: <000001c2d97d$b11814c0$e3026b83@intranet.cir.fr> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/352 X-Sequence-Number: 7550 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