Re: 8.2 planning features

Lists: pgsql-hackers
From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: 8.2 planning features
Date: 2006-03-21 12:47:26
Message-ID: Pine.GSO.4.63.0603211541590.6686@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi there,

I and Teodor are going to give a talk on conference
"Corporate database systems-2006" here in Moscow and we need info about new
features planned in 8.2 release. Bruce, do you have a list of them ?

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83


From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.2 planning features
Date: 2006-03-21 14:02:48
Message-ID: 3954.24.211.165.134.1142949768.squirrel@www.dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Oleg Bartunov said:
> Hi there,
>
> I and Teodor are going to give a talk on conference
> "Corporate database systems-2006" here in Moscow and we need info about
> new features planned in 8.2 release. Bruce, do you have a list of them
> ?
>
>

Speaking of which, I previously said that I intended to work on providing
first class enumeration types for postgres for 8.2. It's now looking very
unlikely that I'll have time to do that, so if any adventurous soul feels
like doing this or is just looking for a project please speak up - I'm quite
prepared to offer help and suggestions. You'll make thousands of migrating
MySQL users happy.

cheers

andrew


From: satoshi nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.2 planning features
Date: 2006-03-21 23:07:03
Message-ID: 44208717.9020308@nttdata.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Oleg,

Refer to the Josh's past talk, "PostgreSQL Directions 8.1 and beyond".
MP3 and materials of are available:

http://www.postgresql.jp/misc/seminar/2006-02-17_18/materials/01_Josh_Berkus.pdf
http://www.postgresql.jp/misc/seminar/2006-02-17_18/materials/01_Josh_Berkus.mp3

Thanks,
Satoshi Nagayasu

Oleg Bartunov wrote:
> Hi there,
>
> I and Teodor are going to give a talk on conference "Corporate database
> systems-2006" here in Moscow and we need info about new features planned
> in 8.2 release. Bruce, do you have a list of them ?
>
>
> Regards,
> Oleg
> _____________________________________________________________
> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
> Sternberg Astronomical Institute, Moscow University, Russia
> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> phone: +007(495)939-16-83, +007(495)939-23-83
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: satoshi nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>
Cc: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.2 planning features
Date: 2006-03-21 23:46:04
Message-ID: 7270.1142984764@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

satoshi nagayasu <nagayasus(at)nttdata(dot)co(dot)jp> writes:
> Oleg Bartunov wrote:
>> I and Teodor are going to give a talk on conference "Corporate database
>> systems-2006" here in Moscow and we need info about new features planned
>> in 8.2 release. Bruce, do you have a list of them ?

> Refer to the Josh's past talk, "PostgreSQL Directions 8.1 and beyond".
> MP3 and materials of are available:

> http://www.postgresql.jp/misc/seminar/2006-02-17_18/materials/01_Josh_Berkus.pdf
> http://www.postgresql.jp/misc/seminar/2006-02-17_18/materials/01_Josh_Berkus.mp3

BTW, pretty pictures such as Josh draws in the above talk should not be
confused with reality ;-). The reality of this project is that *there
is no overall plan*. Individual developers work on what they choose to.
It's true that at the moment there seem to be quite a number of people
focusing on performance in enterprise-size applications, but that's not
because there's any central plan saying that that's what we're doing.

In particular, asking for a list of features that will be done in
particular future releases shows a complete lack of understanding
of the process ...

regards, tom lane


From: satoshi nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.2 planning features
Date: 2006-03-21 23:59:20
Message-ID: 44209358.208@nttdata.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Tom Lane wrote:
> In particular, asking for a list of features that will be done in
> particular future releases shows a complete lack of understanding
> of the process ...

I completely understand.

However, we also need to know why business people want
to know about the future plan. For the business people,
the roadmap is used to know the software is fit to
their (growing) business, not only now but in the future.

Roadmap can be changed, but still roadmap is necessary
for some kind of users.

Just my opinion...

Thanks,
--
NAGAYASU Satoshi <nagayasus(at)nttdata(dot)co(dot)jp>


From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "satoshi nagayasu" <nagayasus(at)nttdata(dot)co(dot)jp>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>, "Pgsql Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.2 planning features
Date: 2006-03-22 00:14:05
Message-ID: 36e682920603211614k3861fd90g5b788f6a129cfa71@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 3/21/06, satoshi nagayasu <nagayasus(at)nttdata(dot)co(dot)jp> wrote:
>
> However, we also need to know why business people want
> to know about the future plan. For the business people,
> the roadmap is used to know the software is fit to
> their (growing) business, not only now but in the future.

With the current timeline, I'll have hierarchical queries, nonrecursive
introspective sort, and insert/update/delete returning ready for 8.2.

--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324


From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: satoshi nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.2 planning features
Date: 2006-03-22 06:24:42
Message-ID: Pine.GSO.4.63.0603220915030.6686@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Tue, 21 Mar 2006, Tom Lane wrote:

> satoshi nagayasu <nagayasus(at)nttdata(dot)co(dot)jp> writes:
>> Oleg Bartunov wrote:
>>> I and Teodor are going to give a talk on conference "Corporate database
>>> systems-2006" here in Moscow and we need info about new features planned
>>> in 8.2 release. Bruce, do you have a list of them ?
>
>> Refer to the Josh's past talk, "PostgreSQL Directions 8.1 and beyond".
>> MP3 and materials of are available:
>
>> http://www.postgresql.jp/misc/seminar/2006-02-17_18/materials/01_Josh_Berkus.pdf
>> http://www.postgresql.jp/misc/seminar/2006-02-17_18/materials/01_Josh_Berkus.mp3
>
> BTW, pretty pictures such as Josh draws in the above talk should not be
> confused with reality ;-). The reality of this project is that *there
> is no overall plan*. Individual developers work on what they choose to.
> It's true that at the moment there seem to be quite a number of people
> focusing on performance in enterprise-size applications, but that's not
> because there's any central plan saying that that's what we're doing.
>
> In particular, asking for a list of features that will be done in
> particular future releases shows a complete lack of understanding
> of the process ...

I didn't expect such a reaction :) I expected people (developers) know what
they choose (or plan) to work on and just share their thoughts. If there would
be any overall plan I'd not asked -hackers at all. I know, for example, that
we're going to work on inverted index support, which scales full text support.

>
> regards, tom lane
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83


From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: satoshi nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Subject: Re: 8.2 planning features
Date: 2006-03-22 19:12:43
Message-ID: 200603221412.43733.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Tuesday 21 March 2006 18:59, satoshi nagayasu wrote:
> Tom Lane wrote:
> > In particular, asking for a list of features that will be done in
> > particular future releases shows a complete lack of understanding
> > of the process ...
>
> I completely understand.
>
> However, we also need to know why business people want
> to know about the future plan. For the business people,
> the roadmap is used to know the software is fit to
> their (growing) business, not only now but in the future.
>
> Roadmap can be changed, but still roadmap is necessary
> for some kind of users.
>

I guess we need all talks like this to have a special slide that points out
that if someone doesn't see the feature they need on the list, they can have
it in the next version as long as they're willing to put some resources
behind it. :-)

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org, satoshi nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Subject: Re: 8.2 planning features
Date: 2006-03-22 19:46:13
Message-ID: 4421A985.4070505@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Robert Treat wrote:

>On Tuesday 21 March 2006 18:59, satoshi nagayasu wrote:
>
>
>>Tom Lane wrote:
>>
>>
>>>In particular, asking for a list of features that will be done in
>>>particular future releases shows a complete lack of understanding
>>>of the process ...
>>>
>>>
>>I completely understand.
>>
>>However, we also need to know why business people want
>>to know about the future plan. For the business people,
>>the roadmap is used to know the software is fit to
>>their (growing) business, not only now but in the future.
>>
>>Roadmap can be changed, but still roadmap is necessary
>>for some kind of users.
>>
>>
>>
>
>I guess we need all talks like this to have a special slide that points out
>that if someone doesn't see the feature they need on the list, they can have
>it in the next version as long as they're willing to put some resources
>behind it. :-)
>
>
>

But it isn't true. Patches get rejected. We won't just automatically
adopt someone's idea if a cool new feature.

My idea of a roadmap would indicate a set of features that had at least
in principle general acceptance and which somebody had undertaken to try
to deliver. Unfortunately, Our TODO list doesn't necessarily meet either
of these criteria. It could also be extended to include some sort of
prioritisation, e.g. "really really want to have", "would like to have",
"would be nice if we can get it in".

The roadmap would be indicative, not prescriptive, i.e. nothing would
stop somebody from delivering a patch for some cool new feature, and
having it considered. And the absence of some feature would not
necessarily inhibit a release. But it would be nice to have some
document that indicated what was likely to be coming down the track
(e.g. I didn't realise that Jonah was going to be doing hierarchical
queries, which will be a very cool thing to have indeed, and one which
many users will drool over.)

cheers

andrew


From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8.2 planning features
Date: 2006-03-25 19:21:50
Message-ID: 200603251121.50956.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Tom,

> BTW, pretty pictures such as Josh draws in the above talk should not be
> confused with reality ;-).

<grin> NOTHING I say should be confused with reality.

--
Josh Berkus
Aglio Database Solutions
San Francisco


From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "satoshi nagayasu" <nagayasus(at)nttdata(dot)co(dot)jp>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>, "Pgsql Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.2 planning features
Date: 2006-03-26 01:42:28
Message-ID: C04B3184.20172%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Satoshi,

On 3/21/06 3:59 PM, "satoshi nagayasu" <nagayasus(at)nttdata(dot)co(dot)jp> wrote:

> However, we also need to know why business people want
> to know about the future plan. For the business people,
> the roadmap is used to know the software is fit to
> their (growing) business, not only now but in the future.
>
> Roadmap can be changed, but still roadmap is necessary
> for some kind of users.

Absolutely.

The Bitmap Index and Sort improvements are features that we have been
developing for the last 10 months based directly on discussions with
business customers. They will be release with Bizgres 0.9 next week, and
contributed to Postgres shortly thereafter (sort already is).

Others on our list of customer driven roadmap items:

- OLAP functions: CUBE, ROLLUP, RANK
- Resource management, incl. dynamic memory management and statement
queueing
- Postgres intrinsic log-shipping replication (we have one to contribute)
- Transparent DML on partitions

Whether these get into 8.2 or not, I'd welcome developer discussion. We are
initiating some planning sessions in mid-April for the next 4-6 months of
development.

- Luke


From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: Luke Lonergan <llonergan(at)greenplum(dot)com>
Cc: satoshi nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.2 planning features
Date: 2006-03-26 02:14:32
Message-ID: 20060325221246.M4637@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


Its relatively easy for a Business to develop a roadmap, since the
managers delegate their programmers to work on specific features ... in
the case of an OSS project, there are no "assignment of features to work
on" happening ... ppl work on what is of interest to them ... so coming up
with anything more then a 'vapor-roadmap' is impossible ...

On Sat, 25 Mar 2006, Luke Lonergan wrote:

> Satoshi,
>
> On 3/21/06 3:59 PM, "satoshi nagayasu" <nagayasus(at)nttdata(dot)co(dot)jp> wrote:
>
>> However, we also need to know why business people want
>> to know about the future plan. For the business people,
>> the roadmap is used to know the software is fit to
>> their (growing) business, not only now but in the future.
>>
>> Roadmap can be changed, but still roadmap is necessary
>> for some kind of users.
>
> Absolutely.
>
> The Bitmap Index and Sort improvements are features that we have been
> developing for the last 10 months based directly on discussions with
> business customers. They will be release with Bizgres 0.9 next week, and
> contributed to Postgres shortly thereafter (sort already is).
>
> Others on our list of customer driven roadmap items:
>
> - OLAP functions: CUBE, ROLLUP, RANK
> - Resource management, incl. dynamic memory management and statement
> queueing
> - Postgres intrinsic log-shipping replication (we have one to contribute)
> - Transparent DML on partitions
>
> Whether these get into 8.2 or not, I'd welcome developer discussion. We are
> initiating some planning sessions in mid-April for the next 4-6 months of
> development.
>
> - Luke
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664


From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8.2 planning features
Date: 2006-03-26 02:58:56
Message-ID: 200603251858.56191.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Marc,

> Its relatively easy for a Business to develop a roadmap, since the
> managers delegate their programmers to work on specific features ... in
> the case of an OSS project, there are no "assignment of features to work
> on" happening ... ppl work on what is of interest to them ... so coming
> up with anything more then a 'vapor-roadmap' is impossible ...

Right. What Luke is saying is that *as a business* GreenPlum is developing
a roadmap for what *they* are going to contribute to PostgreSQL and will
be soliciting input.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Luke Lonergan <llonergan(at)greenplum(dot)com>
Cc: satoshi nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.2 planning features
Date: 2006-03-27 10:16:00
Message-ID: 1143454559.5687.2.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

> - Postgres intrinsic log-shipping replication (we have one to contribute)

Are you saying you have a working WAL-shipping based portable (means
working well on all platforms) replication already done ? Cause I was
looking into implementing just this one :-)

Do you have some details how it works ?

Cheers,
Csaba.