Re: Autovacuum / full vacuum

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum / full vacuum
Date: 2006-01-17 15:07:32
Message-ID: 20060117150732.GY1408@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Jan 17, 2006 at 03:50:38PM +0100, Michael Riess wrote:
>about the FSM: You say that increasing the FSM is fairly cheap - how
>should I know that?

Why would you assume otherwise, to the point of not considering changing
the setting?

The documentation explains how much memory is used for FSM entries. If
you look at vacuum verbose output it will tell you how much memory
you're currently using for the FSM.

Mike Stone

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2006-01-17 15:08:00 Re: Autovacuum / full vacuum
Previous Message Michael Riess 2006-01-17 15:04:41 Re: Autovacuum / full vacuum