Re: Different size in the DATA directory

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Maurício Sessue Otta <mauricio(at)cristorei(dot)com(dot)br>
Cc: dima <_pppp(at)mail(dot)ru>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Different size in the DATA directory
Date: 2002-11-01 15:32:49
Message-ID: 20021101073110.X58632-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 1 Nov 2002, [iso-8859-1] Maurcio 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tim Perdue 2002-11-01 16:02:00 Re: Different size in the DATA directory
Previous Message dima 2002-11-01 15:22:36 Re: Different size in the DATA directory