Il 16/01/2010 14:21, Matteo Beccati ha scritto:
> Il 16/01/2010 11:48, Dimitri Fontaine ha scritto:
>> Matteo Beccati<php(at)beccati(dot)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
>>> 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? :)
Development & Consulting - http://www.beccati.com/
In response to
pgsql-www by date
|Next:||From: Magnus Hagander||Date: 2010-01-18 14:55:00|
|Subject: Re: mailing list archiver chewing patches|
|Previous:||From: webmaster||Date: 2010-01-18 14:00:01|
|Subject: PostgreSQL moderation report: 2010-1-18|
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2010-01-18 14:49:47|
|Subject: Re: Bloom index |
|Previous:||From: Magnus Hagander||Date: 2010-01-18 14:46:02|
|Subject: Re: Streaming Replication on win32|