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