Re: file under data - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: file under data
Date
Msg-id 20011031152107.C19694-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: file under data  ("Leong, Fushan" <fushan.leong@SonoSite.com>)
List 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.




pgsql-admin by date:

Previous
From: "Leong, Fushan"
Date:
Subject: Re: file under data
Next
From: Jeremy Buchmann
Date:
Subject: Re: backup file system