| From: | Gábor Farkas <gabor(at)nekomancer(dot)net> |
|---|---|
| To: | Yonatan Ben-Nes <da(at)canaan(dot)co(dot)il> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Slow search.. quite clueless |
| Date: | 2005-09-22 12:49:41 |
| Message-ID: | 4332A865.3020007@nekomancer.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Howard Cole | 2005-09-22 13:19:00 | ORDER BY results |
| Previous Message | Tom Lane | 2005-09-22 12:23:12 | Re: Problem with libpq3 & postgresql8 |