Skip site navigation (1) Skip section navigation (2)

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

From: Paul Silveira <plabrh1(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Proposal for Implenting read-only queries during wal replay (SoC 2007)
Date: 2007-02-28 04:19:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers

I just wanted to voice my opinion for this feature...  I've implemented a
few Production applicaitons with PostgreSQL now and would die for that
feature.  Right now, I am constantly trying to find way's to make my data
more available.  I've even resulted to using pg_dump to create read only
copies of the database and placed them behind load balancers to make the
data more available.  Something like this would allow me to quickly leverage
a read only node to scale out the applicaiton...  If it can at all be built,
it would get my first, second and third vote. :)


Paul Silveira

Jonah H. Harris-2 wrote:
> On 2/26/07, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>> Jonah, I have no idea what "fault" you are trying to blame on the
>> community in the above statement.  The author didn't discuss the idea
>> with the community before spending months on it so we have no obligation
>> to accept it in the core.
> You're missing the point entirely.  The majority of the (vocal)
> community didn't even want the feature and as such, failed to provide
> viable suggestions for him to move forward.  As the majority of the
> community didn't want the feature, it wouldn't have made a difference
> when he proposed it; which would have remained negative nonetheless.
> -- 
> Jonah H. Harris, Software Architect | phone: 732.331.1324
> EnterpriseDB Corporation            | fax: 732.331.1301
> 33 Wood Ave S, 3rd Floor            | jharris(at)enterprisedb(dot)com
> Iselin, New Jersey 08830            |
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at

View this message in context:
Sent from the PostgreSQL - hackers mailing list archive at

In response to


pgsql-hackers by date

Next:From: Gavin SherryDate: 2007-02-28 04:22:30
Subject: Re: [HACKERS] - WIP Patch Updatable Cursor
Previous:From: John BartlettDate: 2007-02-28 04:14:54
Subject: Re: - WIP Patch Updatable Cursor

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group