Statistics on a table

Поиск
Список
Период
Сортировка
От Maksim Likharev
Тема Statistics on a table
Дата
Msg-id 56510AAEF435D240958D1CE8C6B1770A014A0DF3@mailc03.aurigin.com
обсуждение исходный текст
Ответы Re: Statistics on a table  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Hi,
I just found very interesting situation,
statistic ( n_distinct in particular) records for one of my columns,
greatly under calculated it saying:

49726, but in reality 33409816.

So planer never choose index but rather using table scan, and query
never returns,
is it any way how I can improve that?

I can turn seqscan off but is it safe?

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

Предыдущее
От: "Maksim Likharev"
Дата:
Сообщение: Re: PG crash on simple query, story continues
Следующее
От: Joseph Shraibman
Дата:
Сообщение: where is the list of companies that provide commercial support?