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)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
