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: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster