Re: queries are fast after dump->restore but slow again after some days dispite vacuum

Поиск
Список
Период
Сортировка
От Felix Scheicher
Тема Re: queries are fast after dump->restore but slow again after some days dispite vacuum
Дата
Msg-id loom.20120719T160306-28@post.gmane.org
обсуждение исходный текст
Ответ на queries are fast after dump->restore but slow again after some days dispite vacuum  (Felix Scheicher <mandavi@web.de>)
Ответы Re: queries are fast after dump->restore but slow again after some days dispite vacuum  (Andrew Dunstan <andrew@dunslane.net>)
Re: queries are fast after dump->restore but slow again after some days dispite vacuum  (Jeff Janes <jeff.janes@gmail.com>)
Re: queries are fast after dump->restore but slow again after some days dispite vacuum  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Andrew Dunstan <andrew <at> dunslane.net> writes:

> Try running CLUSTER on the relevant tables and see if it makes a
> difference. If it does you might want to look into using pg_reorg
> periodically.


That worked like a charm! Many thanks. But how comes, the queries are also fast
after a restore without the cluster?

regards,
Felix

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: queries are fast after dump->restore but slow again after some days dispite vacuum
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: queries are fast after dump->restore but slow again after some days dispite vacuum