From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Talking about optimizer, my long dream
Date: Sat, 05 Feb 2011 18:38:07 +1300
Message-ID: <4D4CE23F.4070500@catalyst.net.nz> (raw)
In-Reply-To: <AANLkTimpJf_KudtZGmbR-kBK=OVw6mO6q3+MMocio99f@mail.gmail.com>
References: <AANLkTikMbdPKq_pgihiUOWRnR3eSsn0B1vjMKonq1QrL@mail.gmail.com>
<4D4C0590.1050609@vmsinfo.com>
<4D4C0702.1040909@peak6.com>
<4D4C0EDA.8000704@vmsinfo.com>
<4D4C8F53.8090804@catalyst.net.nz>
<AANLkTimpJf_KudtZGmbR-kBK=OVw6mO6q3+MMocio99f@mail.gmail.com>
O
> If Oracle can patch their query planner for you in 24 hours, and you
> can apply patch with confidence against your test then production
> servers in an hour or so, great. Til then I'll stick to a database
> that has the absolutely, without a doubt, best coder support of any
> project I've ever used.
>
> My point in the other thread is that if you can identify a point where
> a hint would help, like my situation above, you're often better off
> presenting a test case here and getting a patch to make it smarter.
>
By way of contrast - I had a similar situation with DB2 (a few years
ago) with a bad plan being chosen for BETWEEN predicates in some cases.
I found myself having to spend about a hour or two a week chasing the
support organization for - wait for it - 6 months to get a planner patch!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark.kirkwood@catalyst.net.nz, scott.marlowe@gmail.com
Subject: Re: Talking about optimizer, my long dream
In-Reply-To: <4D4CE23F.4070500@catalyst.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox