Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one - Mailing list pgsql-committers

From Bruce Momjian
Subject Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one
Date
Msg-id 200803182056.m2IKuDm10029@momjian.us
Whole thread Raw
In response to Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-committers
Gregory Stark wrote:
> "Bruce Momjian" <bruce@momjian.us> writes:
>
> >> > > On Tue, 2008-03-18 at 03:59 +0000, Bruce Momjian wrote:
> >> > > > * Speed WAL recovery by allowing more than one page to be prefetched
> >> > > >
> >> > > >   This involves having a separate process that can be told which pages
> >> > > >   the recovery process will need in the near future.
> >
> > Are you reading the same thread I am?  See:
> >
> >     http://archives.postgresql.org/pgsql-hackers/2008-02/msg01301.php
>
> I don't think there's any consensus for the approach you describe above. If
> anything it seemed the least objectionable form was something involving
> posix_fadvise or libaio.
>
> Tom did wave us off from Simon's approach on the basis of it being hard to
> test and Heikki seemed to be agreeing on the basis that it would be better to
> reuse infrastructure useful in other cases as well. So I guess that's some
> kind of consensus... of two.

Yep, that was my analysis too.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-committers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one
Next
From: Robert Lor
Date:
Subject: Re: pgsql: Enable probes to work with Mac OS X Leopard and other OSes that