| From: | Yonatan Ben-Nes <da(at)canaan(dot)co(dot)il> |
|---|---|
| To: | Gábor Farkas <gabor(at)nekomancer(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Slow search.. quite clueless |
| Date: | 2005-09-23 11:11:25 |
| Message-ID: | 4333E2DD.5080404@canaan.co.il |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yonatan Ben-Nes | 2005-09-23 11:19:34 | Re: Questions about Rollback - after insert, update, |
| Previous Message | Yonatan Ben-Nes | 2005-09-23 10:51:09 | How many insert + update should one transaction handle? |