X-Original-To: pgsql-admin@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 071CA475A4B for ; Tue, 25 Feb 2003 07:24:05 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 95143-05 for ; Tue, 25 Feb 2003 07:23:49 -0500 (EST) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 57CF9475CA9 for ; Tue, 25 Feb 2003 06:42:51 -0500 (EST) Received: by news.hub.org (Postfix, from userid 8) id 38E1043AF1C; Tue, 25 Feb 2003 06:42:51 -0500 (EST) From: Oleg Samoylov X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Vacuum Question Date: Tue, 25 Feb 2003 14:42:52 +0300 Organization: MIPT Telecom Lines: 39 Message-ID: <3E5B56BC.7060507@telecom.mipt.ru> References: <000001c2d97d$b11814c0$e3026b83@intranet.cir.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529 X-Accept-Language: ru, en To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/385 X-Sequence-Number: 7583 Reindex database also. Look for documentation 7.3.1 , Rounting Reindex. contrib/reindex can help you, even you have older version. Pascal PEYRE wrote: > 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 -- Olleg Samoylov