Re: fate of CLUSTER command ?

Oleg Bartunov wrote:
> On Sat, 3 Aug 2002, Bruce Momjian wrote:
>
> > Oleg Bartunov wrote:
> > > I just tried CLUSTER command at fts.postgresql.org to cluster
> > > fts index and got very visual performance win. Unfortunately
> > > I had to restore permissions and recreate other indices by hand.
> > > So, I'm interested what's a future of CLUSTER command ?
> >
> > Yes, I have always liked CLUSTER with full text searches because you are
> > usually hitting multiple rows with a single equaltiy restriction, and
> > CLUSTER puts all the hits on the same page.
> >
> > If you look in contrib/fulltextindex, you will see mention of CLUSTER in
> > the README. It may make sense to add that to your documentation.
> >
>
> I have to play to get feeling. I don't understand what happens if
> rows will be added to clustered table. Also, what will happens if
> there are several other indices on the same table ? Does clustering
> on one index will decrease performance of queries based on another
> indices ?

Clustering on one index doesn't decrease the performance of the other
indexes. Also, only >=7.3 will preserve all indexes during cluster.
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026