Re: tsearch2 frequent updates - Mailing list pgsql-general

From Oleg Bartunov
Subject Re: tsearch2 frequent updates
Date
Msg-id Pine.GSO.4.63.0507241309550.10181@ra.sai.msu.su
Whole thread Raw
In response to Re: tsearch2 frequent updates  (Steve Atkins <steve@blighty.com>)
List pgsql-general
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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

pgsql-general by date:

Previous
From: Matt Terenzio - BuddyBuilder
Date:
Subject: Tsearch2 and frequent updates
Next
From: "Zlatko Matic"
Date:
Subject: Re: temporary tables ?