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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])