[GENERAL] Simplifying the tsvector format for simple glossaries

2012-01-29 Thread Marc Mamin
Hello, We have a text search on data from error logs, and our application offer a rather simple search on lexemes only (no weighting, no neighbouring ...). This works quite well, except when the applications generating the logs get mad and we have to handle millions of messages per day :-) We

Re: [GENERAL] Simplifying the tsvector format for simple glossaries

2012-01-29 Thread Oleg Bartunov
Always use strip(to_tsvector()) and you'll be happy. Stop words affect tsvector size, so if you don't search them, don't store. strip() function described in docs. Oleg On Sun, 29 Jan 2012, Marc Mamin wrote: Hello, We have a text search on data from error logs, and our application offer a