Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-13 Thread Bruce Momjian
On Mon, May 13, 2019 at 04:01:36PM +0900, Amit Langote wrote: > On 2019/05/11 10:25, Bruce Momjian wrote: > > I struggled to talk about partitioning since there were so many > > improvements. I favored a more generic item that just suggested > > dramatic improvements. I have modified the text to:

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-13 Thread Amit Langote
On 2019/05/11 10:25, Bruce Momjian wrote: > I struggled to talk about partitioning since there were so many > improvements. I favored a more generic item that just suggested > dramatic improvements. I have modified the text to: > > Improve performance of many operations on partitioned tabl

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-10 Thread Bruce Momjian
On Fri, May 10, 2019 at 10:54:32AM +0900, Amit Langote wrote: > On 2019/05/10 5:57, Bruce Momjian wrote: > > So, in this case, there were so many partitioning improvements, I just > > lumped them into one item. I think everyone can consider partitions to > > perform much better in PG 12. Is there

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-10 Thread Bruce Momjian
On Fri, May 10, 2019 at 06:21:27AM +0300, Alexander Korotkov wrote: > + > + > + > + > +Improve speed of btree index insertions (Alexander Korotkov, Peter Geoghegan) > + > > If we group these very heterogeneous together, then Peter's name > probably should go first. Because he authored two quite c

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-10 Thread Alexander Korotkov
On Fri, May 10, 2019 at 6:28 AM Peter Geoghegan wrote: > On Thu, May 9, 2019 at 8:21 PM Alexander Korotkov > wrote: > > If we group these very heterogeneous together, then Peter's name > > probably should go first. Because he authored two quite complex > > optimization, while my one is rather si

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-09 Thread Peter Geoghegan
On Thu, May 9, 2019 at 8:21 PM Alexander Korotkov wrote: > If we group these very heterogeneous together, then Peter's name > probably should go first. Because he authored two quite complex > optimization, while my one is rather simple. I posted a patch over on the "pg12 release notes" thread. I

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-09 Thread Alexander Korotkov
+ + + + +Improve speed of btree index insertions (Alexander Korotkov, Peter Geoghegan) + If we group these very heterogeneous together, then Peter's name probably should go first. Because he authored two quite complex optimization, while my one is rather simple. + + LOOKUP, INDEX CLEANUP IMPROVE

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-09 Thread Amit Langote
On 2019/05/10 5:57, Bruce Momjian wrote: > So, in this case, there were so many partitioning improvements, I just > lumped them into one item. I think everyone can consider partitions to > perform much better in PG 12. Is there something more specific we > should communicate here? So the current

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-09 Thread Tatsuo Ishii
> On Thu, May 9, 2019 at 07:58:00AM +0900, Tatsuo Ishii wrote: >> -- >> >> Move recovery.conf settings into postgresql.conf (Fujii Masao, Simon Riggs, >> Abhijit Menon-Sen, Sergei Kornilov) >> >> >> >> recovery.conf is no longer used, and recovery.signal and standb

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-09 Thread Bruce Momjian
On Wed, May 8, 2019 at 03:45:34PM +0300, Oleg Bartunov wrote: > On Tue, May 7, 2019 at 2:02 AM Bruce Momjian wrote: > > > > docs: fist draft version of the PG 12 release notes > > > > Still needs text markup, links, word wrap, and indenting. > > "This allows JSON values to be selected using an

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-09 Thread Bruce Momjian
On Wed, May 8, 2019 at 04:20:40PM -0400, Alvaro Herrera wrote: > On 2019-May-06, Bruce Momjian wrote: > > > docs: fist draft version of the PG 12 release notes > > Hello, thanks for doing this work once again. > > Typo in surname: "Golgov" is Dolgov. Yes, it was "Golgov" in one commint and "D

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-09 Thread Bruce Momjian
On Wed, May 8, 2019 at 10:09:19PM +0900, Michael Paquier wrote: > On Mon, May 06, 2019 at 11:02:37PM +, Bruce Momjian wrote: > > docs: fist draft version of the PG 12 release notes > > > > Still needs text markup, links, word wrap, and indenting. > > I have noticed a duplicated word: > $ gi

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-09 Thread Bruce Momjian
On Tue, May 7, 2019 at 09:44:54AM +0530, Amit Kapila wrote: > On Tue, May 7, 2019 at 5:00 AM Bruce Momjian wrote: > > > > On Mon, May 6, 2019 at 07:03:39PM -0400, Bruce Momjian wrote: > > > On Mon, May 6, 2019 at 11:02:37PM +, Bruce Momjian wrote: > > > > docs: fist draft version of the PG

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-09 Thread Bruce Momjian
On Tue, May 7, 2019 at 02:38:39PM +0100, Andrew Gierth wrote: > > "Bruce" == Bruce Momjian writes: > > Bruce> docs: fist draft version of the PG 12 release notes > Bruce> Still needs text markup, links, word wrap, and indenting. > > The floating-point output change probably needs to be c

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-09 Thread Bruce Momjian
On Thu, May 9, 2019 at 07:58:00AM +0900, Tatsuo Ishii wrote: > -- > > Move recovery.conf settings into postgresql.conf (Fujii Masao, Simon Riggs, > Abhijit Menon-Sen, Sergei Kornilov) > > > > recovery.conf is no longer used, and recovery.signal and standby.signal a

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-09 Thread Bruce Momjian
On Wed, May 8, 2019 at 10:43:00AM +0900, Amit Langote wrote: > I think there may be two (or more) distinct improvements here. > > * Performance of "pruning" itself which was bottle-necked in the planner > is improved mostly due to: > > +Author: Tom Lane > +2019-03-30 [428b260f8] Speed up planni

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-09 Thread Bruce Momjian
On Tue, May 7, 2019 at 09:08:06PM +1200, Thomas Munro wrote: > On Tue, May 7, 2019 at 11:02 AM Bruce Momjian wrote: > > https://git.postgresql.org/pg/commitdiff/bdf595adbca195fa54a909c74a5233ebc30641a1 > > > +Use pread() and pwrite() for random I/O (Thomas Munro) > > Hi Bruce, > > For this one

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-08 Thread Tatsuo Ishii
-- Move recovery.conf settings into postgresql.conf (Fujii Masao, Simon Riggs, Abhijit Menon-Sen, Sergei Kornilov) recovery.conf is no longer used, and recovery.signal and standby.signal are used to switch into non-primary mode. trigger_file has been renamed to pro

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-08 Thread Alvaro Herrera
On 2019-May-06, Bruce Momjian wrote: > docs: fist draft version of the PG 12 release notes Hello, thanks for doing this work once again. Typo in surname: "Golgov" is Dolgov. This entry: Allow foreign keys to reference partitioned tables (Alvaro Herrera) says "LIMITATIONS?" but I don't think

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-08 Thread Michael Paquier
On Mon, May 06, 2019 at 11:02:37PM +, Bruce Momjian wrote: > docs: fist draft version of the PG 12 release notes > > Still needs text markup, links, word wrap, and indenting. I have noticed a duplicated word: $ git grep "new new" doc/src/sgml/release-12.sgml:Update unaccent rules with new ne

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-08 Thread Oleg Bartunov
On Tue, May 7, 2019 at 2:02 AM Bruce Momjian wrote: > > docs: fist draft version of the PG 12 release notes > > Still needs text markup, links, word wrap, and indenting. "This allows JSON values to be selected using an SQL-standard language." better "This allows to execute complex queries on JSO

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-07 Thread Amit Langote
Hi Bruce, On 2019/05/07 8:02, Bruce Momjian wrote: > docs: fist draft version of the PG 12 release notes > > Still needs text markup, links, word wrap, and indenting. Thanks for crafting these up, as always. About the partitioning performance improvement item: + + + + +Improve performance of

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-07 Thread Andrew Gierth
> "Bruce" == Bruce Momjian writes: Bruce> docs: fist draft version of the PG 12 release notes Bruce> Still needs text markup, links, word wrap, and indenting. The floating-point output change probably needs to be called out as a compatibility issue, not just a performance enhancement. --

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-07 Thread Thomas Munro
On Tue, May 7, 2019 at 11:02 AM Bruce Momjian wrote: > https://git.postgresql.org/pg/commitdiff/bdf595adbca195fa54a909c74a5233ebc30641a1 > +Use pread() and pwrite() for random I/O (Thomas Munro) Hi Bruce, For this one, can we please add Oskari Saarenmaa as first author, and keep me as second?

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-06 Thread Amit Kapila
On Tue, May 7, 2019 at 5:00 AM Bruce Momjian wrote: > > On Mon, May 6, 2019 at 07:03:39PM -0400, Bruce Momjian wrote: > > On Mon, May 6, 2019 at 11:02:37PM +, Bruce Momjian wrote: > > > docs: fist draft version of the PG 12 release notes > > > > > > Still needs text markup, links, word wrap

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-06 Thread Bruce Momjian
On Mon, May 6, 2019 at 07:03:39PM -0400, Bruce Momjian wrote: > On Mon, May 6, 2019 at 11:02:37PM +, Bruce Momjian wrote: > > docs: fist draft version of the PG 12 release notes > > > > Still needs text markup, links, word wrap, and indenting. > > You can see the browser version at: > So

Re: pgsql: docs: fist draft version of the PG 12 release notes

2019-05-06 Thread Bruce Momjian
On Mon, May 6, 2019 at 11:02:37PM +, Bruce Momjian wrote: > docs: fist draft version of the PG 12 release notes > > Still needs text markup, links, word wrap, and indenting. You can see the browser version at: http://momjian.us/tmp/pgsql/release-12.html I will be away tomorrow/Tue

pgsql: docs: fist draft version of the PG 12 release notes

2019-05-06 Thread Bruce Momjian
docs: fist draft version of the PG 12 release notes Still needs text markup, links, word wrap, and indenting. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/bdf595adbca195fa54a909c74a5233ebc30641a1 Modified Files -- doc/src/sgml/release-12.sgml | 2842