Skip site navigation (1) Skip section navigation (2)

Re: TSearch2 performance issue?

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: TSearch2 performance issue?
Date: 2005-04-04 07:12:36
Message-ID: 4250E8E4.8090709@sigaev.ru (view raw or flat)
Thread:
Lists: pgsql-hackers
No, you can't put *.so from 8.0 to 7.4. Get 7.4 sources from cvs and compile 
contrib/tsearch2.

Christopher Kings-Lynne wrote:
> It's a bit tricky, since the machine I noticed it on is in production - 
> how would I test this on a test machine with little data?
> 
> Should I put the 8.0 tsearch2.so on my 7.4 production server?
> 
> Chris
> 
> Teodor Sigaev wrote:
> 
>> I found several unpleasant blot in comparing functions and commit 
>> changes to 7.4, 8.0 and head. Pls check (it need just to recompile .so 
>> file)
>>
>> Christopher Kings-Lynne wrote:
>>
>>>> It's cached. This select should run only one time per connection for 
>>>> each used dictionary. If its'not then it's a bug. I'll check it.
>>>
>>>
>>>
>>>
>>> It probably is then - although I do use a persistent connection pool, 
>>> but I wouldn't have thought that'd use more than a new connection 
>>> every once in a while?
>>>
>>> Chris
>>
>>
>>
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>               http://archives.postgresql.org

-- 
Teodor Sigaev                                   E-mail: teodor(at)sigaev(dot)ru
                                                    WWW: http://www.sigaev.ru/

In response to

pgsql-hackers by date

Next:From: Teodor SigaevDate: 2005-04-04 07:15:52
Subject: Re: TSearch2 performance issue?
Previous:From: Tom LaneDate: 2005-04-04 06:08:46
Subject: Re: BuildFarm status: recent check failures

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group