Re: how to plan for vacuum? - Mailing list pgsql-performance

From Ray Stell
Subject Re: how to plan for vacuum?
Date
Msg-id 20070125134703.GA7869@cns.vt.edu
Whole thread Raw
In response to Re: how to plan for vacuum?  (Galy Lee <lee.galy@oss.ntt.co.jp>)
List pgsql-performance
On Thu, Jan 25, 2007 at 07:29:20PM +0900, Galy Lee wrote:
> so what is the principle to set them?
>  - keep dead space lower than some disk limit
>  - or keep the garbage rate lower than fillfactor
>  or any other general principle?


How do you measure "dead space" and "garbage rate?"

I'm a newbe, I don't even know what these terms mean, but if I can measure
them, perhaps it will gel, and really if you can't measure the effect
of a setting change, what have you got?  I would hope any discussion on
autovac parms would include some metric evaluation techniques.  Thanks.

pgsql-performance by date:

Previous
From: Galy Lee
Date:
Subject: Re: how to plan for vacuum?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: how to plan for vacuum?