| 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: | 20070125134703.GA7869@cns.vt.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-01-25 13:49:35 | WAL Record Header Size Reduction |
| Previous Message | Magnus Hagander | 2007-01-25 13:34:38 | Re: Questions about warnings |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2007-01-25 15:54:24 | Re: how to plan for vacuum? |
| Previous Message | Galy Lee | 2007-01-25 10:52:50 | Re: [PERFORM] how to plan for vacuum? |