Re: [HACKERS] PG 10 release notes

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: [HACKERS] PG 10 release notes
Дата
Msg-id
20170425173748.6oqk2idra5ilhltp@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
[HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: [HACKERS] PG 10 release notes 'Bruce Momjian' <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: [HACKERS] PG 10 release notes 'Bruce Momjian' <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] PG 10 release notes 'Bruce Momjian' <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] PG 10 release notes 'Bruce Momjian' <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] PG 10 release notes "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: [HACKERS] PG 10 release notes "Joshua D. Drake" <jd@commandprompt.com>
Re: [HACKERS] PG 10 release notes Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] PG 10 release notes "Joshua D. Drake" <jd@commandprompt.com>
Re: PG 10 release notes Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: [HACKERS] PG 10 release notes 'Bruce Momjian' <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Claudio Freire <klaussfreire@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Claudio Freire <klaussfreire@gmail.com>
Re: [HACKERS] PG 10 release notes Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] PG 10 release notes Claudio Freire <klaussfreire@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Rafia Sabih <rafia.sabih@enterprisedb.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
[HACKERS] Link to commits in PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] Link to commits in PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] Link to commits in PG 10 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] PG 10 release notes Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes "Daniel Verite" <daniel@manitou-mail.org>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] PG 10 release notes Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] PG 10 release notes Euler Taveira <euler@timbira.com.br>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] PG 10 release notes Merlin Moncure <mmoncure@gmail.com>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Andres Freund <andres@anarazel.de>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Marko Tiikkaja <marko@joh.to>
Re: [HACKERS] PG 10 release notes Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] PG 10 release notes Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] PG 10 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Neha Khatri <nehakhatri5@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] PG 10 release notes Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] PG 10 release notes Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Andrew Borodin <borodin@octonica.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Félix GERZAGUET <felix.gerzaguet@gmail.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes ilmari@ilmari.org (Dagfinn Ilmari Mannsåker)
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes "Tels" <nospam-pg-abuse@bloodgate.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes "Tels" <nospam-pg-abuse@bloodgate.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Jim Nasby <jim@nasby.net>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Adrien Nayrat <adrien.nayrat@dalibo.com>
Re: [HACKERS] PG 10 release notes Adrien Nayrat <adrien.nayrat@dalibo.com>
Re: [HACKERS] PG 10 release notes Adrien Nayrat <adrien.nayrat@dalibo.com>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] PG 10 release notes Adrien Nayrat <adrien.nayrat@dalibo.com>
Re: [HACKERS] PG 10 release notes Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] PG 10 release notes Bruce Momjian <bruce@momjian.us>
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.)
> > 
> >     Author: Álvaro Herrera, loosely based on a submission by Claudio Freire
> >     Discussion:
> > https://postgr.es/m/CAGTBQpa6NFGO_6g_y_7zQx8L9GcHDSQKYdo1tGuh791z6PYgEg@mail.gmail.com
> 
> 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.

I think that's backwards. The truncate operation is quite delicate
because it happens with AccessExclusiveLock held.  This regularly does
cause issues in production.  When users look for things they possibly
should update for, something like "performance improvents in final
vacuum phase" + oneliner is going to be a lot more interesting than,
say, "Add MONEY operators for multiplication and division with INT8
values".

More and more users are going to be primarily interested in three
classes of new things in postgres: 1) performance 2) replication 3)
easier management. Arbitrarily excluding one of the major categories
from release notes isn't a useful policy, especially if we continue to
list new feature that'll effect no more than a handful of people.

- Andres


В списке pgsql-hackers по дате отправления
От: Claudio Freire
Дата:
От: Bruce Momjian
Дата:
FAQ