Re: TSearch2 performance issue? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: TSearch2 performance issue?
Date
Msg-id 424D6FB5.8010608@familyhealth.com.au
Whole thread Raw
In response to Re: TSearch2 performance issue?  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: TSearch2 performance issue?
List pgsql-hackers
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
> 
> 


pgsql-hackers by date:

Previous
From: "Dave Held"
Date:
Subject: Re: ARC patent
Next
From: Bruce Momjian
Date:
Subject: Re: ARC patent