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 16:32:30
Message-ID: 4158409E.8060109@musicrebellion.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
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



In response to

Responses

pgsql-hackers by date

Next:From: Oleg BartunovDate: 2004-09-27 17:02:37
Subject: Re: tsearch2 poor performance
Previous:From: Bruce MomjianDate: 2004-09-27 14:20:43
Subject: Re: [HACKERS] Win32 Version numbering patch

pgsql-admin by date

Next:From: Oleg BartunovDate: 2004-09-27 17:02:37
Subject: Re: tsearch2 poor performance
Previous:From: Gonzales,SDate: 2004-09-27 14:50:42
Subject: securing template1

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