Re: 8.4 release planning

From: Rick Gigger <rick(at)alpinenetworking(dot)com>
To: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
Cc: Dave Page <dpage(at)pgadmin(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, Gregory Stark <stark(at)enterprisedb(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Bernd Helmle <mailings(at)oopsware(dot)de>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8.4 release planning
Date: 2009-01-27 10:33:08
Message-ID: 25793679-1200-40FA-B900-4F39B89DA8FE@alpinenetworking.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Jan 27, 2009, at 2:41 AM, Mark Kirkwood wrote:

> Dave Page wrote:
>> On Mon, Jan 26, 2009 at 8:12 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>
>>> Josh Berkus <josh(at)agliodbs(dot)com> writes:
>>>
>>>> So, some feedback to make this decision more difficult:
>>>> Users: care about HS more than anything else in the world.
>>>>
>>> I don't think this is correct. There are certainly a lot of users
>>> who
>>> would like an in-core replication solution, but HS by itself is
>>> not that
>>> --- you also need (near) real-time log shipping, which we have
>>> already
>>> decided to punt to 8.5. That being the case, I think the argument
>>> that HS is a must-have feature for 8.4 is actually rather weak.
>>>
>>
>> I don't buy that. Sure, sync-rep would be the icing on the cake, but
>> HS with a small archive_timeout (even of the order of 10 or 15
>> minutes) would have been extremely useful on a number of systems I
>> used to run.
>>
>>
>>
> +1
>
> I have customers who want exactly this - a simple to administer,
> query-able slave that does DDL transparently and is up to date
> within a controllable time frame. Bluntly, it looks like a killer
> feature.
>
> regards

+1

So, I am just a lurker here. I mostly follow hackers to find out if
any new features are coming out that will make it worth upgrading, and
to keep up on any backwards compatibly changes that I should be aware
of. I am on 8.1 and it performs well and no features added since then
have seemed worth downing the whole system to do the upgrade for.
However, a simple to administer, query-able slave that does DDL
transparently and is up to date within a controllable time frame is
something that would undoubtably make it worth the upgrade. Whatever
version this feature makes it into will probably be the one I will
upgrade to.

Of course this is just one developer giving you anecdotal evidence and
there are obviously many concerns other than just how in demand it is,
but I just wanted to register my vote that this is a very sought after
feature and it is hard for me to imagine a situation (especially for a
24x7 web application) where having an easy to admin hot standby server
wouldn't help your local DBA sleep better at night.

Rick

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2009-01-27 10:34:56 Patch to add Windows 7 support
Previous Message Bernd Helmle 2009-01-27 10:31:26 Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle