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 4B0D0647020000250002CCC7@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Query times change by orders of magnitude as DB ages  (Richard Neill <rn214@cam.ac.uk>)
Ответы Re: Query times change by orders of magnitude as DB ages  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Список pgsql-performance
Richard Neill <rn214@cam.ac.uk> wrote:

> In terms of just index bloat, does a regular vacuum help?

You might want to use the REINDEX command to correct serious index
bloat.  A regular vacuum will make dead space available for re-use,
but won't eliminate bloat directly.  (If run regularly, it will
prevent bloat.)

-Kevin

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

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