Re: Query times change by orders of magnitude as DB ages

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Query times change by orders of magnitude as DB ages
Дата
Msg-id 4B0D0DCC020000250002CCCE@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Query times change by orders of magnitude as DB ages  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Ответы Re: Query times change by orders of magnitude as DB ages  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Список pgsql-performance
Grzegorz Jaœkiewicz<gryzman@gmail.com> wrote:

> Other way, is to perform regular cluster && reindex

If you CLUSTER there is no reason to REINDEX; indexes are rebuilt by
the CLUSTER command.

Also, if you do a good job with regular VACUUMs, there isn't any bloat
to fix.  In that case a regular CLUSTER would only be needed if it was
worth the cost to keep data physically organized in the index
sequence.

-Kevin

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

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: RAID card recommendation
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: Query times change by orders of magnitude as DB ages