Re: lots of updates on small table - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: lots of updates on small table
Date
Msg-id 20050715003729.GB23728@alvh.no-ip.org
Whole thread Raw
In response to Re: lots of updates on small table  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List 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,
MinLen84, 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)

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: lots of updates on small table
Next
From: David Mitchell
Date:
Subject: Re: performance problems ... 100 cpu utilization