Re: [PERFORM] Large Text Search Help

2003-10-14 Thread Josh Berkus
Mat, > 1. With tsearch2 I get very good query times up until I insert more > records. For example with 100,000 records tsearch2 returns in around 6 > seconds, with 200,000 records tsearch2 returns in just under a minute. > Is this due to the indices fitting entirely in memory with 100,000 > record

[PERFORM] Large Text Search Help

2003-10-14 Thread psql-mail
Hi, I am trying to design a large text search database. It will have upwards of 6 million documents, along with meta data on each. I am currently looking at tsearch2 to provide fast text searching and also playing around with different hardware configurations. 1. With tsearch2 I get very good