Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate.

Поиск
Список
Период
Сортировка
Искать
От
David Gould
Тема
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate.
Дата
Msg-id
20180307182730.4b83f3be@engels
Ответ на
Список
Дерево обсуждения
[patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. David Gould <daveg@sonic.net>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Jeff Janes <jeff.janes@gmail.com>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. David Gould <daveg@sonic.net>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Jeff Janes <jeff.janes@gmail.com>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. David Gould <daveg@sonic.net>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Tom Lane <tgl@sss.pgh.pa.us>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. David Gould <daveg@sonic.net>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Tom Lane <tgl@sss.pgh.pa.us>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. David Gould <daveg@sonic.net>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Tom Lane <tgl@sss.pgh.pa.us>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. David Gould <daveg@sonic.net>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. David Gould <daveg@sonic.net>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Tom Lane <tgl@sss.pgh.pa.us>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. David Gould <daveg@sonic.net>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. David Gould <daveg@sonic.net>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Tom Lane <tgl@sss.pgh.pa.us>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Tom Lane <tgl@sss.pgh.pa.us>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. David Gould <daveg@sonic.net>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Tom Lane <tgl@sss.pgh.pa.us>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. David Gould <daveg@sonic.net>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Robert Haas <robertmhaas@gmail.com>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. David Gould <daveg@sonic.net>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Tom Lane <tgl@sss.pgh.pa.us>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Tom Lane <tgl@sss.pgh.pa.us>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. David Gould <daveg@sonic.net>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Tom Lane <tgl@sss.pgh.pa.us>
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuplesinaccurate. David Gould <daveg@sonic.net>
On Tue, 06 Mar 2018 11:16:04 -0500
Tom Lane  wrote:

> so that we can decide whether this bug is bad enough to justify
> back-patching a behavioral change.  I remain concerned that the proposed
> fix is too simplistic and will have some unforeseen side-effects, so
> I'd really rather just put it in HEAD and let it go through a beta test
> cycle before it gets loosed on the world.

It happens to us fairly regularly and causes lots of problems. However,
I'm agreeable to putting it in head for now, my client can build from
source to pick up this patch until that ships, but doesn't want to maintain
their own fork forever. That said, if it does get though beta I'd hope we
could back-patch at that time.

-dg

-- 
David Gould                                   daveg@sonic.net
If simplicity worked, the world would be overrun with insects.

В списке pgsql-hackers по дате отправления
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Some message fixes
От: Robert Haas
Дата:
FAQ