Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 10:37:48AM -0700, Andres Freund wrote: > On 2017-04-25 13:11:32 -0400, Bruce Momjian wrote: > > I don't think this warrants inclusion in the release notes for reasons > > already discussed. The vacuum truncation operation is a rare one and > > an implementation detail. >

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Tom Lane
Bruce Momjian writes: > On Tue, Apr 25, 2017 at 10:00:52AM -0700, Andres Freund wrote: >> at this point, you can see, we've squarely left O(N) country, and >> entered the vast O(N^2) waste. > OK, I got it now. :-) Here is the new item: > Improve table creation speed

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 02:31:50PM -0300, Claudio Freire wrote: > >> Author: Álvaro Herrera, loosely based on a submission by Claudio Freire > >> Discussion: > >> https://postgr.es/m/cagtbqpa6nfgo_6g_y_7zqx8l9gchdsqkydo1tguh791z6py...@mail.gmail.com > > > > I don't think this warrants

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Andres Freund
On 2017-04-25 13:11:32 -0400, Bruce Momjian wrote: > On Tue, Apr 25, 2017 at 01:37:13PM -0300, Claudio Freire wrote: > > The truncate scan has been measured to be five times faster than without > > this patch (that was on a slow disk, but it shouldn't hurt on fast > > disks.) > > > >

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Claudio Freire
On Tue, Apr 25, 2017 at 2:11 PM, Bruce Momjian wrote: > On Tue, Apr 25, 2017 at 01:37:13PM -0300, Claudio Freire wrote: >> > I think it has been pretty common to accumulate a lot of such changes >> > into generic entries like, say, "speedups for hash joins". More detail >> >

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 10:00:52AM -0700, Andres Freund wrote: > at this point, you can see, we've squarely left O(N) country, and > entered the vast O(N^2) waste. > > 10 109ms > 10 100 22ms > 10 1000162ms > 10 1 1497ms >

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 01:06:05PM -0400, Tels wrote: > Moin, > > On Mon, April 24, 2017 9:31 pm, Bruce Momjian wrote: > > I have committed the first draft of the Postgres 10 release notes. They > > are current as of two days ago, and I will keep them current. Please > > give me any feedback

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 01:37:13PM -0300, Claudio Freire wrote: > > I think it has been pretty common to accumulate a lot of such changes > > into generic entries like, say, "speedups for hash joins". More detail > > than that simply isn't useful to end users; and as a rule, our release > > notes

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Tels
Moin, On Mon, April 24, 2017 9:31 pm, Bruce Momjian wrote: > I have committed the first draft of the Postgres 10 release notes. They > are current as of two days ago, and I will keep them current. Please > give me any feedback you have. Thank you! Here is one thing I noticed: "By default

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Andres Freund
On 2017-04-25 10:10:07 -0400, Bruce Momjian wrote: > On Mon, Apr 24, 2017 at 08:52:05PM -0700, Andres Freund wrote: > > On 2017-04-24 23:45:06 -0400, Tom Lane wrote: > > Oh, I completely agree with accumulating related changes, and that > > code-level details aren't useful. I think we skipped

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Claudio Freire
On Tue, Apr 25, 2017 at 12:45 AM, Tom Lane wrote: > Andres Freund writes: >> On 2017-04-24 23:37:42 -0400, Bruce Momjian wrote: >>> I remember seeing those and those are normally details I do not put in >>> the release notes as there isn't a clear user

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 11:20:46AM -0400, Bruce Momjian wrote: > Oh, I made a mistake there, fixed. > > > > > > > > > New major version numbering (Peter Eisentraut, Tom Lane) > > > > > > Major versions will now increase just the first number, and minor > > releases will increase just the

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 02:39:40PM +0900, Michael Paquier wrote: > > OK, fixed. I also moved some "incompatibility" items into the right > > section. FYI, you can see the most recent doc build here: > > > > http://momjian.us/pgsql_docs/release-10.html > > Here is some feedback based on

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 03:15:45PM +0200, Félix GERZAGUET wrote: > Hello Bruce, > > On Tue, Apr 25, 2017 at 3:31 AM, Bruce Momjian wrote: > > I have committed the first draft of the Postgres 10 release notes.  They > are current as of two days ago, and I will keep them

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 11:09:15AM +0530, Ashutosh Bapat wrote: > Commit f9b1a0dd403ec0931213c66d5f979a3d3e8e7e30 mentions "Ashutosh > Bapat" as author, which is not reflected in the release notes > > -- > Allow explicit control over EXPLAIN's display of planning and > execution time (Stephen

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 06:51:47AM +0200, Petr Jelinek wrote: > On 25/04/17 03:31, Bruce Momjian wrote: > > I have committed the first draft of the Postgres 10 release notes. They > > are current as of two days ago, and I will keep them current. Please > > give me any feedback you have. > > >

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 01:10:35PM +0900, Amit Langote wrote: > On 2017/04/25 10:31, Bruce Momjian wrote: > > I have committed the first draft of the Postgres 10 release notes. They > > are current as of two days ago, and I will keep them current. Please > > give me any feedback you have. > > >

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 04:03:53PM +1200, David Rowley wrote: > ..On 25 April 2017 at 13:31, Bruce Momjian wrote: > > The only unusual thing is that this release has ~180 items while most > > recent release have had ~220. The pattern I see that there are more > > large

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 09:38:55AM +0530, Rafia Sabih wrote: > On Tue, Apr 25, 2017 at 9:15 AM, Tom Lane wrote: > > Andres Freund writes: > >> On 2017-04-24 23:37:42 -0400, Bruce Momjian wrote: > >>> I remember seeing those and those are normally details I

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Mon, Apr 24, 2017 at 08:52:05PM -0700, Andres Freund wrote: > On 2017-04-24 23:45:06 -0400, Tom Lane wrote: > > Andres Freund writes: > > > On 2017-04-24 23:37:42 -0400, Bruce Momjian wrote: > > >> I remember seeing those and those are normally details I do not put in > >

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Mon, Apr 24, 2017 at 08:39:59PM -0700, Andres Freund wrote: > On 2017-04-24 23:37:42 -0400, Bruce Momjian wrote: > > I remember seeing those and those are normally details I do not put in > > the release notes as there isn't a clear user experience change except > > "Postgres is faster". Yeah,

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 09:00:45AM +0530, Amit Kapila wrote: > On Tue, Apr 25, 2017 at 8:35 AM, Bruce Momjian wrote: > > On Tue, Apr 25, 2017 at 08:30:50AM +0530, Amit Kapila wrote: > >> On Tue, Apr 25, 2017 at 7:01 AM, Bruce Momjian wrote: > >> > I have

Re: [HACKERS] PG 10 release notes

2017-04-25 Thread Félix GERZAGUET
Hello Bruce, On Tue, Apr 25, 2017 at 3:31 AM, Bruce Momjian wrote: > I have committed the first draft of the Postgres 10 release notes. They > are current as of two days ago, and I will keep them current. Please > give me any feedback you have. > I just noticed: "Allow

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Michael Paquier
On Tue, Apr 25, 2017 at 10:54 AM, Bruce Momjian wrote: > On Tue, Apr 25, 2017 at 03:45:52AM +0200, Andreas Karlsson wrote: >> On 04/25/2017 03:31 AM, Bruce Momjian wrote: >> >I have committed the first draft of the Postgres 10 release notes. They >> >are current as of two days

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Ashutosh Bapat
Commit f9b1a0dd403ec0931213c66d5f979a3d3e8e7e30 mentions "Ashutosh Bapat" as author, which is not reflected in the release notes -- Allow explicit control over EXPLAIN's display of planning and execution time (Stephen Frost) By default planning and execution is display by EXPLAIN ANALYZE and not

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Petr Jelinek
On 25/04/17 03:31, Bruce Momjian wrote: > I have committed the first draft of the Postgres 10 release notes. They > are current as of two days ago, and I will keep them current. Please > give me any feedback you have. > Cool! > The only unusual thing is that this release has ~180 items while

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Amit Langote
On 2017/04/25 10:31, Bruce Momjian wrote: > I have committed the first draft of the Postgres 10 release notes. They > are current as of two days ago, and I will keep them current. Please > give me any feedback you have. > > The only unusual thing is that this release has ~180 items while most >

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Rafia Sabih
On Tue, Apr 25, 2017 at 9:15 AM, Tom Lane wrote: > Andres Freund writes: >> On 2017-04-24 23:37:42 -0400, Bruce Momjian wrote: >>> I remember seeing those and those are normally details I do not put in >>> the release notes as there isn't a clear user

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread David Rowley
..On 25 April 2017 at 13:31, Bruce Momjian wrote: > The only unusual thing is that this release has ~180 items while most > recent release have had ~220. The pattern I see that there are more > large features in this release than previous ones. Thanks for drafting this up. I

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Andres Freund
On 2017-04-24 23:45:06 -0400, Tom Lane wrote: > Andres Freund writes: > > On 2017-04-24 23:37:42 -0400, Bruce Momjian wrote: > >> I remember seeing those and those are normally details I do not put in > >> the release notes as there isn't a clear user experience change except

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Tom Lane
Andres Freund writes: > On 2017-04-24 23:37:42 -0400, Bruce Momjian wrote: >> I remember seeing those and those are normally details I do not put in >> the release notes as there isn't a clear user experience change except >> "Postgres is faster". Yeah, a bummer, and I can

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Andres Freund
On 2017-04-24 23:37:42 -0400, Bruce Momjian wrote: > On Mon, Apr 24, 2017 at 08:36:00PM -0700, Andres Freund wrote: > > On 2017-04-24 21:31:44 -0400, Bruce Momjian wrote: > > > I have committed the first draft of the Postgres 10 release notes. They > > > are current as of two days ago, and I will

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Bruce Momjian
On Mon, Apr 24, 2017 at 08:36:00PM -0700, Andres Freund wrote: > On 2017-04-24 21:31:44 -0400, Bruce Momjian wrote: > > I have committed the first draft of the Postgres 10 release notes. They > > are current as of two days ago, and I will keep them current. Please > > give me any feedback you

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Andres Freund
On 2017-04-24 21:31:44 -0400, Bruce Momjian wrote: > I have committed the first draft of the Postgres 10 release notes. They > are current as of two days ago, and I will keep them current. Please > give me any feedback you have. > > The only unusual thing is that this release has ~180 items

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Amit Kapila
On Tue, Apr 25, 2017 at 8:35 AM, Bruce Momjian wrote: > On Tue, Apr 25, 2017 at 08:30:50AM +0530, Amit Kapila wrote: >> On Tue, Apr 25, 2017 at 7:01 AM, Bruce Momjian wrote: >> > I have committed the first draft of the Postgres 10 release notes. They >> > are

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Bruce Momjian
On Mon, Apr 24, 2017 at 11:05:41PM -0400, Bruce Momjian wrote: > > I think the above commit needs a separate mention, as this is a really > > huge step forward to control the size of hash indexes. > > Yes, it is unfotunate that the item is in the incompatibility item. I > wonder if I should

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 08:36:38AM +0530, Amit Kapila wrote: > On Tue, Apr 25, 2017 at 8:30 AM, Amit Kapila wrote: > > On Tue, Apr 25, 2017 at 7:01 AM, Bruce Momjian wrote: > >> I have committed the first draft of the Postgres 10 release notes. They >

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Amit Kapila
On Tue, Apr 25, 2017 at 8:30 AM, Amit Kapila wrote: > On Tue, Apr 25, 2017 at 7:01 AM, Bruce Momjian wrote: >> I have committed the first draft of the Postgres 10 release notes. They >> are current as of two days ago, and I will keep them current.

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 08:30:50AM +0530, Amit Kapila wrote: > On Tue, Apr 25, 2017 at 7:01 AM, Bruce Momjian wrote: > > I have committed the first draft of the Postgres 10 release notes. They > > are current as of two days ago, and I will keep them current. Please > > give me

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Amit Kapila
On Tue, Apr 25, 2017 at 7:01 AM, Bruce Momjian wrote: > I have committed the first draft of the Postgres 10 release notes. They > are current as of two days ago, and I will keep them current. Please > give me any feedback you have. > Some of the items which I feel could be

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread 'Bruce Momjian'
All fixed, thanks. --- On Tue, Apr 25, 2017 at 02:40:23AM +, Tsunakawa, Takayuki wrote: > Hello, Bruce > > > From: pgsql-hackers-ow...@postgresql.org > > [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Bruce

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Tsunakawa, Takayuki
Hello, Bruce > From: pgsql-hackers-ow...@postgresql.org > [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Bruce Momjian > I have committed the first draft of the Postgres 10 release notes. They > are current as of two days ago, and I will keep them current. Please give > me any

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Bruce Momjian
On Tue, Apr 25, 2017 at 03:45:52AM +0200, Andreas Karlsson wrote: > On 04/25/2017 03:31 AM, Bruce Momjian wrote: > >I have committed the first draft of the Postgres 10 release notes. They > >are current as of two days ago, and I will keep them current. Please > >give me any feedback you have. >

Re: [HACKERS] PG 10 release notes

2017-04-24 Thread Andreas Karlsson
On 04/25/2017 03:31 AM, Bruce Momjian wrote: I have committed the first draft of the Postgres 10 release notes. They are current as of two days ago, and I will keep them current. Please give me any feedback you have. This item is incorrectly attributed to me. I was only the reviewer, Peter

<    1   2