Re: Statistics use with functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Statistics use with functions
Дата
Msg-id 8956.1241799404@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Statistics use with functions  (Matthew Wakeling <matthew@flymine.org>)
Список pgsql-performance
Matthew Wakeling <matthew@flymine.org> writes:
> Ah, now I see it - I re-analysed, and found entries in pg_stats where
> tablename is the name of the index. Now the query plans correctly and has
> the right estimates. So, one needs to analyse AFTER creating indexes -
> didn't know that.

Yes, for functional indexes it's helpful to do that.  Doesn't matter
for plain-old-plain-old indexes.

            regards, tom lane

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

Предыдущее
От: Paolo Rizzi
Дата:
Сообщение: PostgreSQL with PostGIS on embedded hardware
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Transparent table partitioning in future version of PG?