Re: fate of CLUSTER command ?

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 ?

> Also, is there any value to contrib/fulltextindex now that we have
> contrib/tsearch?
>

they 're different things.

>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83