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

Поиск
Список
Период
Сортировка
От Matthew Wakeling
Тема Re: Query times change by orders of magnitude as DB ages
Дата
Msg-id alpine.DEB.2.00.0911231103420.684@aragorn.flymine.org
обсуждение исходный текст
Ответ на 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  (Richard Neill <rn214@hermes.cam.ac.uk>)
Re: Query times change by orders of magnitude as DB ages  (Richard Neill <rn214@cam.ac.uk>)
Список pgsql-performance
On Sun, 22 Nov 2009, Richard Neill wrote:
> Worse still, doing a cluster of most of the tables and vacuum full analyze

Why are you doing a vacuum full? That command is not meant to be used
except in the most unusual of circumstances, as it causes bloat to
indexes.

If you have run a cluster command, then running vacuum full will make the
table and index layout worse, not better.

Matthew

--
 Riker: Our memory pathways have become accustomed to your sensory input.
 Data:  I understand - I'm fond of you too, Commander. And you too Counsellor

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

Предыдущее
От: Matthew Wakeling
Дата:
Сообщение: Re: Why is the query not using the index for sorting?
Следующее
От: Jonathan Blitz
Дата:
Сообщение: Re: Why is the query not using the index for sorting?