Re: Some thoughts about i/o priorities and throttling vacuum
Matthew T. O'Connor <matthew@zeut.net>
From: "Matthew T. O'Connor" <matthew@zeut.net>
To: Mike Mascari <mascarm@mascari.com>
Cc: Greg Stark <gsstark@mit.edu>, pgsql-hackers@postgresql.org
Date: 2003-10-17T20:50:07Z
Lists: pgsql-hackers
On Fri, 2003-10-17 at 14:56, Mike Mascari wrote: > Greg Stark wrote: > > Ooh strained metaphors. This game is always fun. > > > > So I think of it the other way around. A busy database is like downtown > > traffic with everyone going every which way for short trips. Running vacuum is > > like having a few trucks driving through your city streets for through > > traffic. > > > > Having a parameter to slow down the through traffic is like, uh, having > > express lanes for local traffic. er, yeah, that's the ticket. Except who ever > > heard of having express lanes for local traffic. Hm. > > All I know is that Jan Wieck would have each car filled to the brim > with spikes.... ROTFLAMO