Re: Improving Full text performance

From: Ries van Twisk <pg(at)rvt(dot)dds(dot)nl>
To: xaviergxf <xaviergxf(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Improving Full text performance
Date: 2009-08-22 04:15:19
Message-ID: 4CE0DEC1-9E21-49C8-ADDB-8D8EAE2CDC05@rvt.dds.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In these situations I would suggest to use a real (not that PG's FT is
not real...) search engine
like MNOGoSearch, lucene or others...

Ries

On Aug 21, 2009, at 9:56 PM, xaviergxf wrote:

> Hi,
>
>
> I´m using php and full text on postgresql 8.3 for indexing html
> descriptions. I have no acess to postgresql server, since i use a
> shared hosting service.
> To improve search and performance, i want to do the follow:
>
> Strip all html tags then use my php script to remove more stop words
> (because i can´t edit stop words file on the server).
>
> My question: What i´m thinking to do, has any collateral effects? Any
> suggestions?
>
> Thanks!
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

regards, Ries van Twisk

-------------------------------------------------------------------------------------------------
tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze-DS
WebORB PostgreSQL DB-Architect
email: ries(at)vantwisk(dot)nl web: http://www.rvantwisk.nl/
skype: callto://r.vantwisk
Phone: +1-810-476-4196 Cell: +593 9901 7694 SIP:
+1-747-690-5133

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nathan Jahnke 2009-08-22 05:04:52 Re: bytea corruption?
Previous Message Craig Ringer 2009-08-22 03:08:45 Re: "Could not open relation XXX: No such file or directory"