Re: Slow search.. quite clueless

Gábor Farkas wrote:
> 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

No problem, ill do so :)

Regards,
   Yonatan Ben-Nes