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