Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one
Date: 2008-03-18 20:56:13
Message-ID: 200803182056.m2IKuDm10029@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Gregory Stark wrote:
> "Bruce Momjian" <bruce(at)momjian(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

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

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Lor 2008-03-18 20:59:08 Re: [COMMITTERS] pgsql: Enable probes to work with Mac OS X Leopard and other OSes that
Previous Message Gregory Stark 2008-03-18 20:06:24 Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Lor 2008-03-18 20:59:08 Re: [COMMITTERS] pgsql: Enable probes to work with Mac OS X Leopard and other OSes that
Previous Message Gregory Stark 2008-03-18 20:06:24 Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one