Re: Re: [COMMITTERS] pgsql: Implement multivariaten-distinct coefficients

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: Re: [COMMITTERS] pgsql: Implement multivariaten-distinct coefficients
Дата
Msg-id
20170324192118.7cvlqhfx6p5ecdnd@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
Re: Re: [COMMITTERS] pgsql: Implement multivariaten-distinct coefficients Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: [COMMITTERS] pgsql: Implement multivariate n-distinct coefficients Tom Lane <tgl@sss.pgh.pa.us>
Tom Lane wrote:

> Why not use COSTS OFF?  Or I'll put that even more strongly: all the
> existing regression tests use COSTS OFF, exactly to avoid this sort of
> machine-dependent output.  There had better be a really damn good
> reason not to use it here.

If we use COSTS OFF, the test is completely pointless, as the plans look
identical regardless of whether the multivariate stats are being used or
not.

If we had a ROWS option to ANALYZE that showed estimated number of rows
but not the cost, that would be an option.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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