Search found 8 matches

by wagnerch
Sat Feb 09, 2008 4:31 pm
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 104160

Re: PostgreSQL Fulltext Search

I added a new version to the first post that should support 8.3.
by wagnerch
Thu Jan 31, 2008 1:49 am
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 104160

Re: PostgreSQL Fulltext Search

So - Tried a similar search on a forum I know uses this patch ( postgresqlforums.com ) with a search ( "vacuum -thresholds" ) It works on my site. If you query vacuum you get 45 results, and if you query vacuum -thresholds you get 42 results. The one problem with the mod is that it doesn't deal wit...
by wagnerch
Tue Nov 20, 2007 1:22 am
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 104160

Re: PostgreSQL Fulltext Search

my idea regarding the "exact phrase": -- get the search string from the user -- sanitize it by escaping single quotes only -- pass it as is to the search engine through a query, using single quotes. in other words: completely skip the "split keywords" step. this step only makes sense for the "nativ...
by wagnerch
Sat Nov 17, 2007 11:41 pm
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 104160

Re: PostgreSQL Fulltext Search

Sounds good, if you have an ideas for the "exact phrase" search then I think that would be handy as well.
by wagnerch
Fri Nov 16, 2007 12:20 am
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 104160

Re: PostgreSQL Fulltext Search

* tsearch2 is now fully supported by PhpBB3.x installer, right ? No, this is a customization. * Does your MOD work with PostgreSQL 8.3 beta ? It seems even more easy to use a PostgreSQL beta because tseach2 is integrated. PostgreSQL betas are usually very stable (as strange as it may seem). Only if...
by wagnerch
Tue Aug 21, 2007 11:16 pm
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 104160

Re: PostgreSQL Fulltext Search

I don't think it will get pulled in for the 3.0 release, as far as I know it is in feature freeze. There are a few things that are less than desirable in the current code, such as I am using function based indexes for to_tsvector (because I hate the idea of adding a column for a tsvector, and then i...
by wagnerch
Tue Aug 07, 2007 2:52 am
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 104160

Re: PostgreSQL Fulltext Search

Attached is a version for RC4, the author_search method has changed. As for the caching, it would be interesting to see how the caching performs compared against a huge board. Perhaps I should make this an option for fulltext_postgres? I haven't looked at that code too deeply, it is a possibility I ...
by wagnerch
Sun Jul 22, 2007 10:23 pm
Forum: [3.0/Olympus] New features discussion
Topic: PostgreSQL Fulltext Search
Replies: 40
Views: 104160

PostgreSQL Fulltext Search

I know there has been a few discussions about implementing a fulltext module for PostgreSQL. I guess my first question is has anyone actually done it? I should probably mention that I have done it, and it appears to work. It uses tsearch2, I am interested in what others have done. If you are upgradi...