Re: Vacuum thoughts

From: Neil Conway <neilc(at)samurai(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Vacuum thoughts
Date: 2003-10-17 20:48:31
Message-ID: 1066423711.581.58.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 2003-10-17 at 16:22, Greg Stark wrote:
> If it's just a matter of all the read i/o from vacuum then we're best off
> sleeping for a few milliseconds every few kilobytes. If it's the cache then
> we're probably better off reading a few megabytes and then sleeping for
> several seconds to allow the other buffers to get touched and pushed back to
> the front of the LRU.

Uh, no -- if it is the cache, we're better off fixing the buffer
replacement policy, not trying to hack around it. Replacement policies
that don't suffer from sequential flooding are well known.

-Neil

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthew T. O'Connor 2003-10-17 20:50:07 Re: Some thoughts about i/o priorities and throttling vacuum
Previous Message Joshua D. Drake 2003-10-17 20:46:25 Writers Wanted