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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
