Re: [HACKERS] CREATE STATISTICS statistic_type documentation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] CREATE STATISTICS statistic_type documentation
Дата
Msg-id 16072.1495731948@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] CREATE STATISTICS statistic_type documentation  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: [HACKERS] CREATE STATISTICS statistic_type documentation  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> On Thu, May 25, 2017 at 9:28 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Where would you expect to find that?

> Probably at the end of the paragraph:
> "A statistic type to be computed in this statistics object. Currently
> supported types are ndistinct, which enables n-distinct statistics, and
> dependencies, which enables functional dependency statistics. For more
> information, see Section 14.2.2 and Section 68.2."

Fair enough.

> Something like "If omitted, both ndistinct and dependencies will be
> included."

> If we invent more types in the future, would we expect those to be
> defaulted to as well?

I might be wrong, but my impression is that the plan is to default
to gathering all possible stats types.  So I'd probably write the
addendum that way rather than naming those two types specifically.
        regards, tom lane



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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: [HACKERS] CREATE STATISTICS statistic_type documentation
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Surjective functional indexes