Re: Database size growing over time and leads to performance impact

Поиск
Список
Период
Сортировка
От Scott Carey
Тема Re: Database size growing over time and leads to performance impact
Дата
Msg-id CB770C9C-F676-4153-8CBF-C698C253DD11@richrelevance.com
обсуждение исходный текст
Ответ на Re: Database size growing over time and leads to performance impact  (Andy Colson <andy@squeakycode.net>)
Ответы Re: Database size growing over time and leads to performance impact  (Robert Haas <robertmhaas@gmail.com>)
Re: Database size growing over time and leads to performance impact  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
On Mar 27, 2010, at 6:35 AM, Andy Colson wrote:
>
> Dont "VACUUM FULL", its not helping you, and is being removed in newer versions.
>

Off topic:  How is that going to work?  CLUSTER doesn't work on tables without an index.  I would love to be able to
CLUSTERon some column set that doesn't necessarily have an index. 

> -Andy
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance


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

Предыдущее
От: David Wilson
Дата:
Сообщение: Re: query has huge variance in execution times
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Database size growing over time and leads to performance impact