Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2C35F474E53 for ; Fri, 1 Nov 2002 10:32:49 -0500 (EST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id B4AFF474E44 for ; Fri, 1 Nov 2002 10:32:48 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id AEAF4D616; Fri, 1 Nov 2002 07:32:49 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id A46135C04; Fri, 1 Nov 2002 07:32:49 -0800 (PST) Date: Fri, 1 Nov 2002 07:32:49 -0800 (PST) From: Stephan Szabo To: =?iso-8859-1?Q?Maur=EDcio_Sessue_Otta?= Cc: dima <_pppp@mail.ru>, Subject: Re: Different size in the DATA directory In-Reply-To: <008b01c281b2$901bd4a0$cba0a2c8@cristorei.com.br> Message-ID: <20021101073110.X58632-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN Content-Transfer-Encoding: QUOTED-PRINTABLE X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/6 X-Sequence-Number: 10148 On Fri, 1 Nov 2002, [iso-8859-1] Maur=EDcio Sessue Otta wrote: > I do daily vacuums on the production server You haven't said what version you're running, but if you're using 7.2 and non-FULL vacuums you also will want to make sure that you have the free space map settings in postgresql.conf are large enough. Also, you may need to use reindex to lower the space usage by indexes.