Il 16/01/2010 14:21, Matteo Beccati ha scritto:
Il 16/01/2010 11:48, Dimitri Fontaine ha scritto:
Matteo Beccati<p...@beccati.com> writes:
Anyway, I've made further changes and I would say that at this point
the PoC
is feature complete. There surely are still some rough edges and a few
things to clean up, but I'd like to get your feedback once again:
[...]
Also, I'd need some help with the CTE query that was picking a wrong
plan
and led me to forcibly disable merge joins inside the application when
executing it. Plans are attached.
Sorry, not from me, still a CTE noob.
Actually the live db doesn't suffer from that problem anymore, but I've
able to reproduce the issue with a few days old backup running on a test
8.5alpha3 instance that still has a stock postgresql.conf.
Following advice from Andrew "RodiumToad" Gierth, I raised cpu costs
back to the defaults (I did lower them following some tuning guide) and
that seems to have fixed the problem.
My question now is... what next? :)
Cheers
--
Matteo Beccati
Development & Consulting - http://www.beccati.com/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
