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 по дате отправления: