X-Original-To: pgsql-admin@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 09F9B474E4F for ; Sun, 23 Feb 2003 15:55:30 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 23418-06 for ; Sun, 23 Feb 2003 15:55:19 -0500 (EST) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id B157B475A45 for ; Sun, 23 Feb 2003 15:54:39 -0500 (EST) Received: by news.hub.org (Postfix, from userid 8) id 9240243A928; Sun, 23 Feb 2003 15:54:39 -0500 (EST) From: "Daniel Schuchardt" X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Vacuum Question Date: Sun, 23 Feb 2003 13:19:16 +0100 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 39 Message-ID: References: <000001c2d97d$b11814c0$e3026b83@intranet.cir.fr> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/2 X-Sequence-Number: 7650 Do a VACUUM FULL on your database. This should be the solution. Daniel ""Pascal PEYRE"" schrieb im Newsbeitrag news:000001c2d97d$b11814c0$e3026b83@intranet.cir.fr... > 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 > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster