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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
