Re: Experimental patch for inter-page delay in VACUUM

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Experimental patch for inter-page delay in VACUUM
Date: 2003-10-31 05:16:40
Message-ID: 3FA1F038.8050804@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

>Attached is an extremely crude prototype patch for making VACUUM delay
>by a configurable amount between pages,
>
Cool!

>Assuming that this is found to be useful, the following issues would
>have to be dealt with before the patch would be production quality:
>
>2. I only bothered to insert delays in the processing loops of plain
> VACUUM and btree index cleanup. VACUUM FULL and cleanup of non-btree
> indexes aren't done yet.
>
>
I thought we didn't want the delay in vacuum full since it locks things
down, we want vacuum full to finish ASAP. As opposed to normal vacuum
which would be fired by the autovacuum daemon.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2003-10-31 05:23:08 Re: 7.4RC1 planned for Monday
Previous Message Tom Lane 2003-10-31 05:01:53 Re: Call for port reports