Postgresql strong enough for PriceComparison.com?

[PriceComparison]

Hello Fellow Programmers..

I am one of the programmer on a new dot com called 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

[stuka]

When considering the performance of a database for a particular application, particularly one where speed is of the essence, you can't just say "is database X strong enough?". You need to consider several factors, including how the web server and database are connected, whether or not your database server is dedicated to your database, what hardware the server is running, how (or even *if*) the database is tuned (presumably this db gets hit a LOT more for reads than writes, for example - is the system set up for a fairly extensive cache?), and, of course, how well you are querying the database, and how the indices are set up to facilitate that. Have your DBA types check on those issues LONG before moving DB platforms!