From: | Jean-Michel Pouré <jmpoure(at)poure(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Tsearch2 / Create rule on select |
Date: | 2007-03-08 20:56:23 |
Message-ID: | 1173387383.12072.12.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear Friends,
I am very impressed by TSearch2 and would like to thank Oleg and the
team for their hard work.
I would like to migrate a phpBB forum with more that 200.000 messages to
TSeach. Full text searches have become a bottleneck. When there are more
than 200 users, the server slow dramatically. I need TSearch!
So ... I installed TSearch2, a French dictionnary, everything is okay.
My database is PostgreSQL 8.2.3, UTF-8.
My questions now:
1) Should I migrate phpBB to TSeach2 in PHP code, rewriting the queries,
which is quite obvious or easy.
OR
2) Is there a smart way to catch queries on the fly in PostgreSQL, for
example using
"CREATE RULE "_RETURN" AS
ON SELECT TO t1
DO INSTEAD "
or the like.
The idea would be that when I search on a text field, PostgreSQL rule system would rewrite the query to seach using Tsearch2.
Is there any tool in TSeach2 doing this query rewriting rule?
Obviously, it does not seem to exist, but I would like to be sure.
3) Gin indexes
Are Gin indexes recommended for large databases?
How to calculate the size in memory of an index?
Kind regards,
Jean-Michel
From | Date | Subject | |
---|---|---|---|
Next Message | Jorge Godoy | 2007-03-08 21:02:53 | Re: No buffer space available |
Previous Message | Bill Moran | 2007-03-08 20:18:49 | Re: security permissions for functions |