Re: 9.5 release notes
От
Bruce Momjian
Тема
Re: 9.5 release notes
Дата
Msg-id
20150806213812.GM13687@momjian.us
Ответ на
Re: 9.5 release notes (Andres Freund)
Список
Дерево обсуждения
9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Alvaro Herrera <alvherre@2ndquadrant.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Alvaro Herrera <alvherre@2ndquadrant.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Petr Jelinek <petr@2ndquadrant.com>
Re: 9.5 release notes Alvaro Herrera <alvherre@2ndquadrant.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Alvaro Herrera <alvherre@2ndquadrant.com>
Re: 9.5 release notes Tatsuo Ishii <ishii@postgresql.org>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Stephen Frost <sfrost@snowman.net>
Re: 9.5 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Alvaro Herrera <alvherre@2ndquadrant.com>
Re: 9.5 release notes Michael Paquier <michael.paquier@gmail.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Jan de Visser <jan@de-visser.net>
Re: 9.5 release notes Kouhei Kaigai <kaigai@ak.jp.nec.com>
Re: 9.5 release notes Alvaro Herrera <alvherre@2ndquadrant.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Alvaro Herrera <alvherre@2ndquadrant.com>
Re: 9.5 release notes Andres Freund <andres@anarazel.de>
Re: 9.5 release notes Kevin Grittner <kgrittn@ymail.com>
Re: 9.5 release notes Robert Haas <robertmhaas@gmail.com>
Re: 9.5 release notes Andres Freund <andres@anarazel.de>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Alvaro Herrera <alvherre@2ndquadrant.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Andres Freund <andres@anarazel.de>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Andres Freund <andres@anarazel.de>
Re: 9.5 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: 9.5 release notes Andres Freund <andres@anarazel.de>
Re: 9.5 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: 9.5 release notes Andres Freund <andres@anarazel.de>
Re: 9.5 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: 9.5 release notes Andres Freund <andres@anarazel.de>
Re: 9.5 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: 9.5 release notes Andres Freund <andres@anarazel.de>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Andres Freund <andres@anarazel.de>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Robert Haas <robertmhaas@gmail.com>
Re: 9.5 release notes Andres Freund <andres@anarazel.de>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Andres Freund <andres@anarazel.de>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: 9.5 release notes David Rowley <david.rowley@2ndquadrant.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Arthur Silva <arthurprs@gmail.com>
Re: 9.5 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: 9.5 release notes Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Robert Haas <robertmhaas@gmail.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Robert Haas <robertmhaas@gmail.com>
Re: 9.5 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: 9.5 release notes Robert Haas <robertmhaas@gmail.com>
Re: 9.5 release notes Alvaro Herrera <alvherre@2ndquadrant.com>
Re: 9.5 release notes Robert Haas <robertmhaas@gmail.com>
Re: 9.5 release notes Rajeev rastogi <rajeev.rastogi@huawei.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Amit Kapila <amit.kapila16@gmail.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Amit Kapila <amit.kapila16@gmail.com>
Re: 9.5 release notes Michael Paquier <michael.paquier@gmail.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Dean Rasheed <dean.a.rasheed@gmail.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Robert Haas <robertmhaas@gmail.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Fujii Masao <masao.fujii@gmail.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes David Rowley <david.rowley@2ndquadrant.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Robert Haas <robertmhaas@gmail.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Robert Haas <robertmhaas@gmail.com>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Robert Haas <robertmhaas@gmail.com>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Robert Haas <robertmhaas@gmail.com>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Bruce Momjian <bruce@momjian.us>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
Re: 9.5 release notes Peter Geoghegan <pg@heroku.com>
On Wed, Jun 24, 2015 at 11:34:27AM +0200, Andres Freund wrote: > On 2015-06-23 21:08:36 -0400, Robert Haas wrote: > > On Tue, Jun 23, 2015 at 5:48 PM, Kevin Grittner wrote: > > > Andres Freund wrote: > > >>> > > >>> > > >>> Improve concurrent locking and buffer scan performance (Andres > > >>> Freund, Kevin Grittner) > > >>> > > >>> > > >> > > >> If this is ab5194e6f, I don't think it makes sense to mention "buffer > > >> scan" - it's just any lwlock, and buffer locks aren't the primary > > >> benefit (ProcArrayLock, buffer mapping lock probably are that). I also > > > > > >> don't think Kevin was involved? > > > > > > It seems likely that 2ed5b87f9 was combined with something else in > > > this reference. By reducing buffer pins and buffer content locking > > > during btree index scans it shows a slight performance gain in > > > btree scans and avoids some blocking of btree index vacuuming. > > Oh. That's what it was combined with. I don't think it makes sense to > throw these three items together into one note. Their benefit/risk > potential is pretty different. I believe Andres has made all these adjustments suggested. If not, please let me know. > > I think maybe we should separate that back out. The list needs to be > > user-accessible, but if it's hard to understand what it's referring > > to, that's not good either. > > Yea. And if then Bruce goes and compares feature counts... :) :-) -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
В списке pgsql-hackers по дате отправления