Horton
Menu

Re: mailing list archiver chewing patches

Matteo Beccati <php@beccati.com>

View thread
From: Matteo Beccati <php@beccati.com>
To: Dimitri Fontaine <dfontaine@hi-media.com>
Cc: David Fetter <david@fetter.org>, Aidan Van Dyk <aidan@highrise.ca>, Magnus Hagander <magnus@hagander.net>, Dave Page <dpage@pgadmin.org>, Abhijit Menon-Sen <ams@toroid.org>, Alvaro Herrera <alvherre@commandprompt.com>, Andrew Dunstan <andrew@dunslane.net>, Tim Bunce <Tim.Bunce@pobox.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2010-01-18T14:48:12Z
Lists: pgsql-hackers 
Il 16/01/2010 14:21, Matteo Beccati ha scritto:
> Il 16/01/2010 11:48, Dimitri Fontaine ha scritto:
>> Matteo Beccati<php@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/