Postgresql able to power PriceComparison.com?

[PriceComparison]

Hello Fellow Programmers..

I am one of the programmer on a new dot com called

http://www.PriceComparison.com.

The project is quite a success so far, but as we add more and more merchant products, the "Keyword Search" became slower and slower. At the time of this writting we have surpassed the 2 millions products mark (we have inserted into postgresql) only for the product table.

We know the current size is still an infancy state.
When PriceComparison.com goes full swing it could easy increase 20 - 50x that size.

I have looked into FTI (Full text indexing) technology, but seems to be quite complex. Can anyone suggest anything?

Try our search here:

http://www.PriceComparison.com

Any help or idea will be appreciated.

Thanks

Andrew@PriceComparison.com

 

[ceco]

fulltext searching is always complicated ;-)

see tsearch2 in the contrib I find it quite useful

 

[PriceComparison]

Yes Tsearch2 is the one I read about, the solutions sounds good but the complexity of installation and backup.

Is there any easier solution?