Multivariate MCV lists -- pg_mcv_list_items() seems to be broken

Поиск
Список
Период
Сортировка
От Dean Rasheed
Тема Multivariate MCV lists -- pg_mcv_list_items() seems to be broken
Дата
Msg-id CAEZATCX6T0iDTTZrqyec4Cd6b4yuL7euu4=rQRXaVBAVrUi1Cg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Multivariate MCV lists -- pg_mcv_list_items() seems to be broken  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Re: Multivariate MCV lists -- pg_mcv_list_items() seems to be broken  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I just noticed the following:

CREATE TABLE foo (a int, b int);
INSERT INTO foo SELECT x/10, x/100 FROM generate_series(1, 100) x;
CREATE STATISTICS foo_s ON a,b FROM foo;
ANALYSE foo;

SELECT pg_mcv_list_items(stxmcv) from pg_statistic_ext WHERE stxname = 'foo_s';

which fails with

ERROR:  cache lookup failed for type 0

That definitely used to work, so I'm guessing it got broken by the
recent reworking of the serialisation code, but I've not looked into
it.

There should probably be regression test coverage of that function.

Regards,
Dean



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Zedstore - compressed in-core columnar storage
Следующее
От: Tom Lane
Дата:
Сообщение: Re: plpgsql - execute - cannot use a reference to record field