Re: new heapcheck contrib module

Поиск
Список
Период
Сортировка
Искать
От
Mark Dilger
Тема
Re: new heapcheck contrib module
Дата
Msg-id
ABBF7CB8-0FCA-4611-962A-1BA17E6621BB@enterprisedb.com
Ответ на
Список
Дерево обсуждения
new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Andres Freund <andres@anarazel.de>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Dilip Kumar <dilipbalaut@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Dilip Kumar <dilipbalaut@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module (typos) Erik Rijkers <er@xs4all.nl>
Re: new heapcheck contrib module (typos) Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Dilip Kumar <dilipbalaut@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Alvaro Herrera <alvherre@2ndquadrant.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Alvaro Herrera <alvherre@2ndquadrant.com>
Re: new heapcheck contrib module Dilip Kumar <dilipbalaut@gmail.com>
Re: new heapcheck contrib module Dilip Kumar <dilipbalaut@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Dilip Kumar <dilipbalaut@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Andres Freund <andres@anarazel.de>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Andres Freund <andres@anarazel.de>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Andres Freund <andres@anarazel.de>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Amul Sul <sulamul@gmail.com>
Re: new heapcheck contrib module Amul Sul <sulamul@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Amul Sul <sulamul@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Amul Sul <sulamul@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Amul Sul <sulamul@gmail.com>
Re: new heapcheck contrib module Amul Sul <sulamul@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Michael Paquier <michael@paquier.xyz>
Re: new heapcheck contrib module "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Stephen Frost <sfrost@snowman.net>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Andrey Borodin <x4mmm@yandex-team.ru>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Thomas Munro <thomas.munro@gmail.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Thomas Munro <thomas.munro@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Andres Freund <andres@anarazel.de>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Alvaro Herrera <alvherre@2ndquadrant.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Alvaro Herrera <alvherre@2ndquadrant.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Alvaro Herrera <alvherre@2ndquadrant.com>
Re: new heapcheck contrib module Tom Lane <tgl@sss.pgh.pa.us>
Re: new heapcheck contrib module Michael Paquier <michael@paquier.xyz>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Robert Haas <robertmhaas@gmail.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>
Re: new heapcheck contrib module Mark Dilger <mark.dilger@enterprisedb.com>
Re: new heapcheck contrib module Peter Geoghegan <pg@bowt.ie>


> On Aug 2, 2020, at 8:59 PM, Peter Geoghegan  wrote:
> 
> What's the point in not just giving up on the index (though not
> necessarily the table or other indexes) at the first sign of trouble,
> anyway? It makes sense for the heap structure, but not for indexes.

The case that came to mind was an index broken by a glibc update with breaking changes to the collation sort order underlying the index.  If the breaking change has already been live in production for quite some time before a DBA notices, they might want to quantify how broken the index has been for the last however many days, not just drop and recreate the index.  I'm happy to drop that from the patch, though.

—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company





В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Mark Dilger
Дата:
FAQ