Re: [HACKERS] 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

Re: [HACKERS] fate of CLUSTER command ?

On Sun, 4 Aug 2002, Christopher Kings-Lynne wrote: 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

Re: [HACKERS] fate of CLUSTER command ?

I'm working on a new version of it for 7.3. What have you got in mind? Well I have patches from Florian and someone else. Some wide character stuff, non-indexable word support, full word match search support, speed and space optimisations, etc. I'm just trying to set it up in a

Re: [HACKERS] 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

[HACKERS] fate of CLUSTER command ?

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 ? Regards, Oleg

Re: [HACKERS] fate of CLUSTER command ?

Oleg Bartunov dijo: 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 ? I'm working on CLUSTER. I

Re: [HACKERS] fate of CLUSTER command ?

On Sat, 3 Aug 2002, Alvaro Herrera wrote: Oleg Bartunov dijo: 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

Re: [HACKERS] fate of CLUSTER command ?

Oleg Bartunov dijo: On Sat, 3 Aug 2002, Alvaro Herrera wrote: Oleg Bartunov dijo: 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,

Re: [HACKERS] fate of CLUSTER command ?

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

Re: [HACKERS] fate of CLUSTER command ?

Also, let me add that CLUSTER in 7.3 will be fully functional because we will no longer be changing the oid of the table during cluster. This will allow people to use CLUSTER more frequently/safely. --- Bruce Momjian

Re: [HACKERS] fate 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

Re: [HACKERS] fate of CLUSTER command ?

Christopher Kings-Lynne [EMAIL PROTECTED] writes: Also, is there any value to contrib/fulltextindex now that we have contrib/tsearch? I haven't looked at tsearch yet, but I expect it's way better than fulltextindex. However there's more than a few of us using fulltextindex, so I think it