Re: Slow search.. quite clueless

Yonatan Ben-Nes wrote:
> Dawid Kuroczko wrote:
>> Hmm, JOIN on a Huge table with LIMIT.  You may be suffering from
>> the same problem I had:
>>
>> http://archives.postgresql.org/pgsql-performance/2005-07/msg00345.php
>>
>> Tom came up with a patch which worked marvellous in my case:
>>
>> http://archives.postgresql.org/pgsql-performance/2005-07/msg00352.php
>>
>> Try applying this patch, it may solve your problem!
>>
>>    Regards,
>>         Dawid
>>
>
> Great then ill check it if the tsearch2 wont work (testing in about 2-3
> hours...).

please post your results here too (if possible) ;)

i'm very interested in your research (we are also having performance
problems, so i also thought about tsearch2...)

thanks,
gabor