Re: file under data

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "Leong, Fushan" <fushan(dot)leong(at)SonoSite(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: file under data
Date: 2001-10-31 23:25:07
Message-ID: 20011031152107.C19694-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 31 Oct 2001, Leong, Fushan wrote:

> delete them is bad.. but you can not let them grow forever........
>
> When and how to clean up these files?

You should VACUUM ANALYZE occasionally depending your rate of
updates and deletes on your tables. I think you'll also need
to use REINDEX when you want to shrink the index space. I
believe there's information about these commands in the
admin documentation.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jeremy Buchmann 2001-11-01 00:26:53 Re: backup file system
Previous Message Leong, Fushan 2001-10-31 23:10:20 Re: file under data