Re: read-only queries on PITRslaves, any progress?

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Alexander Staubo" <alex(at)purefiction(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, "Marinos Yannikos" <mjy(at)geizhals(dot)at>
Subject: Re: read-only queries on PITRslaves, any progress?
Date: 2007-09-18 14:55:32
Message-ID: b42b73150709180755l3dd17d50wefb1753606f87f53@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/18/07, Alexander Staubo <alex(at)purefiction(dot)net> wrote:
> On 9/15/07, Marinos Yannikos <mjy(at)geizhals(dot)at> wrote:
> > this might not be the best place to ask, but has there been any further
> > progress or an alternative project to Florian Pflug's SoC 2007 proposal
> > about enabling PITR slaves to serve read-only queries? It seems like an
> > elegant way to load-balance a PostgreSQL database with very little overhead.
>
> I too would love to hear about this.

Florian has been hard at work on getting the lazy xid assignment patch
in for 8.3, which is now complete. AIUI, this is an important step
towards read only pitr slave (with other advantages too), and shows
that things are moving along. I don't have a crystal ball, but I'm
guessing you will start to hear more about this when the 8.3 beta is
wrapped.

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-09-18 14:55:42 Re: Q:Aggregrating Weekly Production Data. How do you do it?
Previous Message Bill Moran 2007-09-18 13:40:43 Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER