Re: Problem with n_distinct being consistently inaccurate.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with n_distinct being consistently inaccurate.
Дата
Msg-id 22043.1064347653@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problem with n_distinct being consistently inaccurate.  ("Nick Fankhauser" <nickf@ontko.com>)
Ответы Re: Problem with n_distinct being consistently inaccurate.
Список pgsql-admin
"Nick Fankhauser" <nickf@ontko.com> writes:
> when I do a \d on pg_stats, it appears that pg_statistic.starelid matches up
> with pg_class.oid, but apparently this is not the case.

It certainly should be the case.  starelid matches to pg_class.oid and
staattnum matches to pg_attribute.attnum.

            regards, tom lane

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

Предыдущее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: Problem with n_distinct being consistently inaccurate.
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: help needed!!!