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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
