On Sat, 23 Jul 2005, Steve Atkins wrote:
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.
in 8.1 performance should be certainly improved because we added
concurrency & recovery suppot to GiST. Currently, whole table should be
exclusively locked for every update.
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
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
