Re: [GENERAL] tsearch is slow

2006-03-15 Thread Abbath
Hello Scott, Wednesday, March 15, 2006, 8:49:00 PM, you wrote: > On Wed, 2006-03-15 at 13:36, Abbath wrote: >> Hello Richard, >> >> Wednesday, March 15, 2006, 3:35:26 PM, you wrote: >> > If you want to force the data to be cached, just put a cron-job in to >>

Re: [GENERAL] tsearch is slow

2006-03-15 Thread Abbath
Hello Richard, Wednesday, March 15, 2006, 3:35:26 PM, you wrote: > Abbath wrote: >> is slow for the first time (7-15 sec), but then using the same keyword >> next time it is fast (10-100 ms). The reason is, as I read, first time >> it is not cached at all, but next tim

[GENERAL] tsearch is slow

2006-03-15 Thread Abbath
me at 1 million records, I think it is not a big expectation nowadays) Abbath ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [GENERAL] tsearch2 match substrings

2006-03-03 Thread Abbath
ust use the "beg" (or "beg*" ) search expression. > Potentially yes, but without index support and it's needed to write your > operator/function. Could You write some sample how do You mean? Thanks in advance. -- Abbath ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] tsearch2 match substrings

2006-03-03 Thread Abbath
27;like':3 'match':5 'begin':7 ...etc" then it would be cool to create a query, which give me a headline for "begin" if I just use the "beg" (or "beg*" ) search expression. Is there a way to solve this? Thanks in advance. Abbath -