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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-02-28 05:10:57 | Re: Resumable vacuum proposal and design overview |
Previous Message | Galy Lee | 2007-02-28 04:53:01 | Re: Resumable vacuum proposal and design overview |