From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: full-text indexing |
Date: | 2000-04-19 00:40:13 |
Message-ID: | 200004190040.UAA12994@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Does anyone have any experience using Postgres's full-text indexing in a
> production environment? We're thinking about using it for a project (the
> other solution is to regexp it with Perl...). I've set up the stuff
> before for experimentation, but am mainly curious about it's performance
> on a live, fairly heavily trafficked server.
I have one word for you: CLUSTER. Without it, index lookups are too
slow. With it, they are rapid. I have done some work like this
commerically with Ingres, which has an ISAM type that keeps the matching
rows pretty close on a newly-created ISAM index. In PostgreSQL, and
regular CLUSTER will keep you good.
If you find it slow, let me know. I have done some benchmarking with
the author and he found it pretty fast, usually a few seconds. See the
section in my book on CLUSTER for information on _why_ it helps.
http://www.postgresql.org/docs/awbook.html
--
Bruce Momjian | http://www.op.net/~candle
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
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2000-04-19 00:44:46 | Re: What are your using it for? |
Previous Message | rcook | 2000-04-19 00:08:43 | What are your using it for? |