Skip site navigation (1) Skip section navigation (2)

Re: how to plan for vacuum?

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: Galy Lee <lee(dot)galy(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-performance(at)postgresql(dot)org, jim(at)nasby(dot)net
Subject: Re: how to plan for vacuum?
Date: 2007-01-25 13:47:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-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.

In response to

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2007-01-25 15:54:24
Subject: Re: how to plan for vacuum?
Previous:From: Galy LeeDate: 2007-01-25 10:52:50
Subject: Re: [PERFORM] how to plan for vacuum?

pgsql-hackers by date

Next:From: Simon RiggsDate: 2007-01-25 13:49:35
Subject: WAL Record Header Size Reduction
Previous:From: Magnus HaganderDate: 2007-01-25 13:34:38
Subject: Re: Questions about warnings

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group