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

Re: tsearch2 poor performance

From: Kris Kiger <kris(at)musicrebellion(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: tsearch2 poor performance
Date: 2004-09-27 17:30:49
Message-ID: 41584E49.5040301@musicrebellion.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
Oleg,

    Thanks for the help on this.

    The query I used to return the 508 number is:
         SELECT * FROM stat('SELECT vector FROM product') ORDER BY ndoc 
desc, word ;
   
    Testing says, the more words I use, the faster the query is.  My 
original search word, 'oil', appears in 226,357 documents 233,266 times. 
 As far as distinct words go, 'oil' is middle of the road for 
occurences.  As it is set up now, the best search time I am getting on 
this single word is roughly 22 seconds.  

Kris

Oleg Bartunov wrote:

>Kris,
>
>do you actually have only 508 disctinct words ? Could you try
>more complex queries, say 2-3 words. Does these queries run faster ?
>
>
>	Oleg
>On Mon, 27 Sep 2004, Kris Kiger wrote:
>
>  
>
>>Regardless of caching, the queries are still taking 19~20 seconds to run
>>on the 3,000,000 rows.  I've played with performance tuning and nothing
>>seems to make much of a difference.  If I am reading that list from stat
>>correctly, then I am operating on  508 distinct words.  Is this the
>>performance I should expect from tsearch2?  Or is something still awry?
>> I'm inclined to think  something else is wrong, after reading some
>>other people's tsearch performance stats.  Thanks!
>>
>>Kris
>>
>>    
>>
>	Regards,
>		Oleg
>  
>


In response to

Responses

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2004-09-27 17:36:17
Subject: Re: tsearch2 poor performance
Previous:From: Oleg BartunovDate: 2004-09-27 17:02:37
Subject: Re: tsearch2 poor performance

pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2004-09-27 17:36:17
Subject: Re: tsearch2 poor performance
Previous:From: Oleg BartunovDate: 2004-09-27 17:02:37
Subject: Re: tsearch2 poor performance

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