Re: [PERFORM] Keyword searching question

2004-07-06 Thread borajetta
Forgot to mention that were running post gres 7.4.2 using a dual optiron system and 4gig ram. The results are used by the PHP web server. Thanks again - Original Message - From: borajetta To: [EMAIL PROTECTED] Sent: Tuesday, July 06, 2004 10:52 AM Subject: Keywor

[PERFORM] Keyword searching question

2004-07-06 Thread borajetta
I have been trying to get keyword searching quicker and have now decided to make smaller tables.   I was working with tables of about 50 000 000 rows but now will use about 1.5million rows, I am using a TSearch2 to find keywords in the titles column of the rows.  I have indexes using a gist i