From: Ray Stell <stellr@cns.vt.edu>
To: Galy Lee <lee.galy@oss.ntt.co.jp>
Cc: pgsql-performance@postgresql.org
Cc: jim@nasby.net
Subject: Re: how to plan for vacuum?
Date: Thu, 25 Jan 2007 08:47:03 -0500
Message-ID: <20070125134703.GA7869@cns.vt.edu> (raw)
In-Reply-To: <45B88680.4040500@oss.ntt.co.jp>
References: <45B6F0A8.1050705@oss.ntt.co.jp>
<20070125033917.GD64372@nasby.net>
<45B88680.4040500@oss.ntt.co.jp>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: stellr@cns.vt.edu, lee.galy@oss.ntt.co.jp, jim@nasby.net
Subject: Re: how to plan for vacuum?
In-Reply-To: <20070125134703.GA7869@cns.vt.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox