Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum full - Mailing list pgsql-performance

From scott.marlowe
Subject Re: vacuum full
Date
Msg-id Pine.LNX.4.33.0211211032170.23081-100000@css120.ihs.com
Whole thread Raw
In response to vacuum full  ("Henrik Steffen" <steffen@city-map.de>)
List pgsql-performance
Tree view 
On Thu, 21 Nov 2002, Henrik Steffen wrote:

>
> hello all,
>
> how often should "vacuum full" usually be run ?

I recommend nightly.  Also, check index size.  If they are growing, you
may want to reindex each night or week as well.

pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: H/W RAID 5 on slower disks versus no raid on faster
Next
From: "scott.marlowe"
Date:
Subject: Re: Is there a system of cache in pgsql 7.3rc1 ?