| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Neeraj Sharma <neerajk_s(at)yahoo(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Postres dilemma |
| Date: | 2004-06-07 03:39:18 |
| Message-ID: | 23607.1086579558@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> Why are you running a vacuum every 45 seconds? Increase your fsm_pages and
> run it every hour.
If I understood his description correctly, he's turning over 10% of a
500-row table every minute. So waiting an hour would mean 3000 dead
rows in a 500-live-row table, which seems excessive. I'd agree with
running a vacuum on this specific table every five minutes or so.
Given that he is doing more than enough vacuums, I think that the
problem is probably not table bloat, but index bloat (ie, from a
constantly shifting range of live index keys, which pre-7.4 btrees
didn't handle well at all). This is just speculation though, without
proof as yet.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jihuang | 2004-06-07 04:22:05 | Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL? |
| Previous Message | Joshua D. Drake | 2004-06-07 02:58:08 | Re: Postres dilemma |