Re: caching indexes and pages?

Поиск
Список
Период
Сортировка
От Thomas Finneid
Тема Re: caching indexes and pages?
Дата
Msg-id 4978EC01.6080107@fcon.no
обсуждение исходный текст
Ответ на Re: caching indexes and pages?  (Thomas Markus <t.markus@proventis.net>)
Ответы Re: caching indexes and pages?
Re: caching indexes and pages?
Список pgsql-performance
Thomas Markus wrote:

> try to reorganize your data with CLUSTER and create appropriate indixes
> (dont forget to check statistics).

One question. Assume I have clustered and new data has been added after
that, according to the docs that data is added "outside" of the
clustered data. What happens when I run cluster again? I would assume
its smart and to only clusteres the new data, i.e. adding it to the
already created clusters, as apporpriate, so the execution time would be
a lot lower, right? or would it run through and recluster everything
from scratch again?

thomas


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

Предыдущее
От: David Rees
Дата:
Сообщение: Re: postgresql 8.3 tps rate
Следующее
От: Kenneth Marshall
Дата:
Сообщение: Re: caching indexes and pages?