Re: tsearch2 poor performance - Mailing list pgsql-admin

From Kris Kiger
Subject Re: tsearch2 poor performance
Date
Msg-id 4158409E.8060109@musicrebellion.com
Whole thread Raw
In response to Re: tsearch2 poor performance  ("Gregory S. Williamson" <gsw@globexplorer.com>)
Responses Re: tsearch2 poor performance  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Christian Fowler
Date:
Subject: short lines in big dump prevent backup
Next
From: Oleg Bartunov
Date:
Subject: Re: tsearch2 poor performance