Re: Clustered indexes - When to use them?

Scott Marlowe wrote:
> On Wed, 2005-11-02 at 13:50, MaXX wrote:
[...]
>> In simple words:
>> Clustered indexes are like the alphabetical index in a book, where term
>> are randomly distibuted in the book and regular indexes are more like the
>> table of content...
>> Right?
> Not really. It's more like if someone reordered the book so that it was
> in the same order as whatever index you have in it. So, if the index
> was on the length of the words, the words in the book would be reordered
> to be smallest to largest (or reverse that). If the index were on just
> the words themselves, then the book would have the words reordered from
> A to Z etc...
Things become more clear now...

> Note that clustered indexes do not dynamically update the table order in
> postgresql. If you're gonna insert to them, you need to recluster them
> every so often.
Good to know it...

Thanks,
--
MaXX