Re: tsearch2 frequent updates

On Sat, Jul 23, 2005 at 02:37:42PM -0400, Matthew Terenzio wrote:

> If I'm using Tsearch2 to search a public online forum, do you think 
> it's okay to update on every forum entry?
> 
> Put another way: is to_tsvector() resource intensive when used in this 
> way?

Depends on the update rate, I suspect. I found it far too slow for 5+
new messages a second back when it was new.

But you're probably handling less than that, and it's improved since
then.

You should probably benchmark a reaonable test case and see.

Cheers,
  Steve