Re: tsearch2 frequent updates

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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83