Re: Experimental patch for inter-page delay in VACUUM

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Experimental patch for inter-page delay in VACUUM
Date: 2003-11-10 19:05:22
Message-ID: 155300000.1068491122@lerlaptop-red.iadfw.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

--On Monday, November 10, 2003 13:40:24 -0500 Neil Conway
<neilc(at)samurai(dot)com> wrote:

> Larry Rosenman <ler(at)lerctr(dot)org> writes:
>> You might also look at Veritas' advisory stuff.
>
> Thanks for the suggestion -- it looks like we can make use of
> this. For the curious, the cache advisory API is documented here:
>
> http://www.lerctr.org:8458/en/man/html.7/vxfsio.7.html
> http://www.lerctr.org:8458/en/ODM_FSadmin/fssag-9.html#MARKER-9-1
>
> Note that unlike for posix_fadvise(), the docs for this functionality
> explicitly state:
>
> Some advisories are currently maintained on a per-file, not a
> per-file-descriptor, basis. This means that only one set of
> advisories can be in effect for all accesses to the file. If two
> conflicting applications set different advisories, both use the
> last advisories that were set.
BTW, if ANY developer wants to play with this, I can make an account for
them. I have ODM installed on lerami.lerctr.org (www.lerctr.org is a
CNAME).

LER

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-11-10 19:05:37 Re: Experimental patch for inter-page delay in VACUUM
Previous Message Bruce Momjian 2003-11-10 19:03:56 Re: Experimental patch for inter-page delay in VACUUM