2010/1/18 Matteo Beccati <p...@beccati.com>: > 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? :)
If it wasn't for the fact that we're knee deep in two other major projects for the infrastructure team right now, I'd be all over this :-) But we really need to complete that before we put anything new in production here. What I'd like to see is one that integrates with our general layouts. Also, I tink one of the main issues with the archives today that people bring up is the inability to have threads cross months. I think that should be fixed. Basically, get rid of the grouping by month for a more dynamic way to browse. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers