[HACKERS] Searching for substring with tsearch(1/2)

2003-12-09 Thread Urmo
ut a day before I lost my pacience and canceled it). I even modified it to lose suffixes and index only full words but it was still too slow (50K records were indexed in 24h). Can anybody help or point out right direction? Or is this even (easily) doable with tsearch1 or tsearc

Re: [HACKERS] Searching for substring with tsearch(1/2)

2003-12-09 Thread Urmo
oneintegercolumn = oneintgercolumn. oneintegercolumn does not have any constraints or indexes what could be reason for decreased performance. Urmo wrote: Hi, there seems to be no way of searching partial matches with tsearch. Would it be hard to implement prefix based matching, i.e. "hu" matc