Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Bruce Momjian
Hitoshi Harada wrote: > 2010/3/21 Bruce Momjian : > > Hitoshi Harada wrote: > >> 2010/3/20 Bruce Momjian : > >> > I have completed the 9.0 release notes: > >> > > >> > ? ? ? ?http://developer.postgresql.org/pgdocs/postgres/release-9-0.html > >> > > >> > >> I wonder if we need note a minor compatibi

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Hitoshi Harada
2010/3/21 Bruce Momjian : > Hitoshi Harada wrote: >> 2010/3/20 Bruce Momjian : >> > I have completed the 9.0 release notes: >> > >> > ? ? ? ?http://developer.postgresql.org/pgdocs/postgres/release-9-0.html >> > >> >> I wonder if we need note a minor compatibility from extending window >> function's

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Bruce Momjian
Tom Lane wrote: > Josh Berkus writes: > > I'd favor a beta sooner rather than later even if some stuff is still in > > flux. This particular release needs as much testing as possible, and > > 10x as many people will try a beta as an alpha. > > Well, the reason they are willing to try a beta is t

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Pavel Stehule
2010/3/20 Tom Lane : > Josh Berkus writes: >> I'd favor a beta sooner rather than later even if some stuff is still in >> flux.  This particular release needs as much testing as possible, and >> 10x as many people will try a beta as an alpha. > > Well, the reason they are willing to try a beta is

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Bruce Momjian
Josh Berkus wrote: > On 3/19/10 9:02 PM, Bruce Momjian wrote: > > I have completed the 9.0 release notes: > > > > http://developer.postgresql.org/pgdocs/postgres/release-9-0.html > > > > I kept the 9.0-alpha release notes in the SGML because people might want > > to compare them with the rele

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Tom Lane
Josh Berkus writes: > I'd favor a beta sooner rather than later even if some stuff is still in > flux. This particular release needs as much testing as possible, and > 10x as many people will try a beta as an alpha. Well, the reason they are willing to try a beta is that it's supposed to be more

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Josh Berkus
Tom, Bruce, I'd favor a beta sooner rather than later even if some stuff is still in flux. This particular release needs as much testing as possible, and 10x as many people will try a beta as an alpha. -- -- Josh Berkus Post

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Josh Berkus
On 3/19/10 9:02 PM, Bruce Momjian wrote: > I have completed the 9.0 release notes: > > http://developer.postgresql.org/pgdocs/postgres/release-9-0.html > > I kept the 9.0-alpha release notes in the SGML because people might want > to compare them with the release notes I did, and because th

[HACKERS] Windowing Qual Pushdown

2010-03-20 Thread Daniel Farina
In the function "subquery_is_pushdown_safe", there is an immediate "false" returned if the subquery has a windowing function. While that seems true in general, are there cases where we can push down a qual if it is on the partitioning key? Or do NULLs or some other detail get in the way? fdr --

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Andrew Dunstan
Bruce Momjian wrote: Well, Tom and I have already posted publicly about it. There is nothing that either us see on the 9.0 "Bugs" open items list that would delay a beta: http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items I have just been looking at the xmlconcat bug on th

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Tom Lane
Bruce Momjian writes: > Robert Haas wrote: >> I think we need you and Tom and other senior community members to >> weigh in a little more overtly on which of the remaining open items >> should get fixed prior to 9.0beta. > Well, Tom and I have already posted publicly about it. There is nothing >

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Bruce Momjian
Bruce Momjian wrote: > I have completed the 9.0 release notes: > > http://developer.postgresql.org/pgdocs/postgres/release-9-0.html > > Interestingly the 9.0 release notes contain 201 items, while the 8.4 > release notes contained 314 items. Of course we will be adding a few > more 9.0 ite

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Bruce Momjian
Robert Haas wrote: > > Interestingly the 9.0 release notes contain 201 items, while the 8.4 > > release notes contained 314 items. ?Of course we will be adding a few > > more 9.0 items before 9.0 final, but not a lot. ?The only explanation I > > can think of is that we were more focused during this

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Bruce Momjian
Hitoshi Harada wrote: > 2010/3/20 Bruce Momjian : > > I have completed the 9.0 release notes: > > > > ? ? ? ?http://developer.postgresql.org/pgdocs/postgres/release-9-0.html > > > > I wonder if we need note a minor compatibility from extending window > function's frame. > > - Change BETWEEN from

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Robert Haas
On Sat, Mar 20, 2010 at 12:02 AM, Bruce Momjian wrote: > I have completed the 9.0 release notes: > >        http://developer.postgresql.org/pgdocs/postgres/release-9-0.html > > I kept the 9.0-alpha release notes in the SGML because people might want > to compare them with the release notes I did,

Re: [HACKERS] 9.0 release notes done

2010-03-20 Thread Hitoshi Harada
2010/3/20 Bruce Momjian : > I have completed the 9.0 release notes: > >        http://developer.postgresql.org/pgdocs/postgres/release-9-0.html > I wonder if we need note a minor compatibility from extending window function's frame. - Change BETWEEN from TYPE_FUNC_NAME_KEYWORD from COL_NAME_KEYWO

Re: [HACKERS] Streaming replication status

2010-03-20 Thread Simon Riggs
On Thu, 2010-01-14 at 17:33 +0900, Fujii Masao wrote: > I added two new functions; > > (1) pg_last_xlog_receive_location() reports the last WAL location received > and synced by walreceiver. If streaming replication is still in progress > this will increase monotonically. If streaming rep