Re: Problem after VACUUM ANALYZE

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Problem after VACUUM ANALYZE
Дата
Msg-id dcc563d10804080938v3d142483rfe335da4c4e286dc@mail.gmail.com
обсуждение исходный текст
Ответ на Problem after VACUUM ANALYZE  (mljv@planwerk6.de)
Ответы Re: Problem after VACUUM ANALYZE
Список pgsql-general
It sounds to me like two possible problems, maybe combined.

One possibility is that you have a data distribution that results in
statistics being gathered that don't really represent your data.  Try
increasing the stats target for that column (or the whole db if you'd
rather) and re-running analyze.

The other possibility is that you've got some index bloat happening
and you might benefit from  reindexing the problematic table.

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

Предыдущее
От: Alan Hodgson
Дата:
Сообщение: Re: Problem after VACUUM ANALYZE
Следующее
От: Tom Lane
Дата:
Сообщение: Re: tsvector_update_trigger throws error "column is not of tsvector type"