Re: Proposal for Implenting read-only queries during wal replay (SoC 2007)

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>, Postgresql-General <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal for Implenting read-only queries during wal replay (SoC 2007)
Date: 2007-02-23 23:27:49
Message-ID: 20070223232749.GI11743@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Feb 23, 2007 at 10:57:24PM +0000, Heikki Linnakangas wrote:
> Florian G. Pflug wrote:
> >I plan to submit a proposal for implementing support for
> >read-only queries during wal replay as a "Google Summer of Code 2007"
> >project.
> >
> >I've been browsing the postgres source-code for the last few days,
> >and came up with the following plan for a implementation.
> >
> >I'd be very interested in any feedback on the propsoal - especially
> >of the "you overlooked this an that, it can never work that way" kind ;-)
>
> I had the same thought roughly two years ago:
>
> http://archives.postgresql.org/pgsql-hackers/2005-11/msg01043.php
>
> People weren't very interested in having a read-only mode. I think it
> would be a nice feature if it's not too complicated.

Every customer I've ever talked to about HA has either asked about it or
thought it was a great idea. We should definitely do it if it's not a
load of difficult..
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-02-23 23:32:07 Re: 5 Weeks till feature freeze or (do you know where your patch is?)
Previous Message Tom Lane 2007-02-23 23:26:46 Re: pg_autovacuum should allow NULL values