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

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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Paul Silveira <plabrh1(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Proposal for Implenting read-only queries during wal replay (SoC 2007)
Date: 2007-02-28 05:08:58
Message-ID: 45E50E6A.8060902@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Paul Silveira wrote:
> Hello,
> 
> 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. 

Paul unfortunately you have responded to a hijacked thread. Jonah was
speaking about a project that he wishes would have been accepted which
was called Full Disjunctions.

I have not read the read-only queries during wal replay thread but I can
assure you that Jonah's response had nothing to do with it.

Joshua D. Drake



 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. :)
> 
> Regards,
> 
> 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            | http://www.enterprisedb.com/
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 7: You can help support the PostgreSQL project by donating at
>>
>>                 http://www.postgresql.org/about/donate
>>
>>
> 


-- 

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2007-02-28 05:10:57
Subject: Re: Resumable vacuum proposal and design overview
Previous:From: Galy LeeDate: 2007-02-28 04:53:01
Subject: Re: Resumable vacuum proposal and design overview

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