Re: Auto Vacuum Daemon (again...)

On Fri, 2002-11-29 at 07:19, Shridhar Daithankar wrote:
> On 29 Nov 2002 at 7:59, Matthew T. O'Connor wrote:
>
> > On Thursday 28 November 2002 23:26, Shridhar Daithankar wrote:
> > > On 28 Nov 2002 at 10:45, Tom Lane wrote:
> > > > This is almost certainly a bad idea. vacuum is not very
> > > > processor-intensive, but it is disk-intensive. Multiple vacuums running
> > > > at once will suck more disk bandwidth than is appropriate for a
> > > > "background" operation, no matter how sexy your CPU is. I can't see
> > > > any reason to allow more than one auto-scheduled vacuum at a time.
> > > Hmm.. We would need to take care of that as well..
> > Not sure what you mean by that, but it sounds like the behaviour of my AVD
> > (having it block until the vacuum command completes) is fine, and perhaps
> > preferrable.
>
> Right.. But I will still keep option open for parallel vacuum which is most
> useful for reusing tuples in shared buffers.. And stale updated tuples are what
> causes performance drop in my experience..
>
> You know.. just enough rope to hang themselves..;-)
>

Right. This is exactly what I was thinking about. If someone shoots
their own foot off, that's their problem. The added flexibility seems
well worth it.

Greg