Re: vacuum full

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Henrik Steffen <steffen(at)city-map(dot)de>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: vacuum full
Date: 2002-11-21 17:32:44
Message-ID: Pine.LNX.4.33.0211211032170.23081-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

  • vacuum full at 2002-11-21 16:52:05 from Henrik Steffen

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message scott.marlowe 2002-11-21 17:38:20 Re: Is there a system of cache in pgsql 7.3rc1 ?
Previous Message scott.marlowe 2002-11-21 17:32:05 Re: H/W RAID 5 on slower disks versus no raid on faster