| From: | Matteo Beccati <php(at)beccati(dot)com> |
|---|---|
| To: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com> |
| Cc: | David Fetter <david(at)fetter(dot)org>, Aidan Van Dyk <aidan(at)highrise(dot)ca>, Magnus Hagander <magnus(at)hagander(dot)net>, Dave Page <dpage(at)pgadmin(dot)org>, Abhijit Menon-Sen <ams(at)toroid(dot)org>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: mailing list archiver chewing patches |
| Date: | 2010-01-18 14:48:12 |
| Message-ID: | 4B5474AC.4090800@beccati.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-www |
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
>>> 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-01-18 14:49:47 | Re: Bloom index |
| Previous Message | Magnus Hagander | 2010-01-18 14:46:02 | Re: Streaming Replication on win32 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2010-01-18 14:55:00 | Re: mailing list archiver chewing patches |
| Previous Message | webmaster | 2010-01-18 14:00:01 | PostgreSQL moderation report: 2010-1-18 |