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.
In response to
pgsql-performance by date
|Next:||From: Jim C. Nasby||Date: 2007-01-25 15:54:24|
|Subject: Re: how to plan for vacuum?|
|Previous:||From: Galy Lee||Date: 2007-01-25 10:52:50|
|Subject: Re: [PERFORM] how to plan for vacuum?|
pgsql-hackers by date
|Next:||From: Simon Riggs||Date: 2007-01-25 13:49:35|
|Subject: WAL Record Header Size Reduction|
|Previous:||From: Magnus Hagander||Date: 2007-01-25 13:34:38|
|Subject: Re: Questions about warnings|