| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Alison Winters <alison(at)mirrabooka(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: lots of updates on small table |
| Date: | 2005-07-15 00:37:30 |
| Message-ID: | 20050715003729.GB23728@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Jul 14, 2005 at 08:28:24PM -0400, Alvaro Herrera wrote:
> On Fri, Jul 15, 2005 at 09:42:12AM +1000, Alison Winters wrote:
>
> > INFO: Pages 1221: Changed 3, reaped 256, Empty 0, New 0; Tup 108137: Vac 4176, Keep/VTL 108133/108133, UnUsed 19, MinLen 84, MaxLen 84; Re-using: Free/Avail. Space 445176/371836; EndEmpty/Avail. Pages 0/256.
>
> Hmm, so it seems your hourly vacuum is enough. I think the bloat theory
> can be trashed. Unless I'm reading this output wrong; I don't remember
> the details of this vacuum output.
Ok, so I was _very_ wrong :-) Sorry.
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
Essentially, you're proposing Kevlar shoes as a solution for the problem
that you want to walk around carrying a loaded gun aimed at your foot.
(Tom Lane)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Mitchell | 2005-07-15 00:43:07 | Re: performance problems ... 100 cpu utilization |
| Previous Message | Alvaro Herrera | 2005-07-15 00:28:24 | Re: lots of updates on small table |