From: Tom Lane <tgl@sss.pgh.pa.us>
To: Craig James <cjames@emolecules.com>
Cc: Atri Sharma <atri.jiit@gmail.com>
Cc: Stefan Keller <sfkeller@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Getting query plan alternatives from query planner?
Date: Fri, 21 Mar 2014 10:06:51 -0400
Message-ID: <15381.1395410811@sss.pgh.pa.us> (raw)
In-Reply-To: <CAFwQ8rd1jY6U8qQ9EahuKFpeZrSCS1vsY9GAmb3LvAGkBB9cSQ@mail.gmail.com>
References: <CAFcOn2-9j4fTcJ39xvdCByF6dg3U_=TGumCCp1-7SH_J9G+GtA@mail.gmail.com>
<15606.1395335330@sss.pgh.pa.us>
<CAFcOn2_cv6tDwnc1w+aDz0hUiRY4Xh2ran4A14X9iApWWdU_XA@mail.gmail.com>
<CAOeZVifDg=Q6V-iAwLHr7zfUDFpGkqsKK-s108VrfbL0GaOQ9g@mail.gmail.com>
<CAFwQ8rd1jY6U8qQ9EahuKFpeZrSCS1vsY9GAmb3LvAGkBB9cSQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Craig James <cjames@emolecules.com> writes:
> There have been many discussions about adding hints to Postgres over the
> years. All have been firmly rejected by the Postgres developers, with
> well-argued reasons. Search the archives to learn more about this topic.
To clarify: there are good reasons not to like what Oracle calls hints.
On the other hand, the concept of hints that tell the planner what
selectivity or rowcount to expect (as opposed to trying to control the
plan directly) has met with generally more positive reviews. There's
no specific design yet, and certainly no implementation roadmap, but
I'd not be surprised if we get something like that a few years down
the road.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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: tgl@sss.pgh.pa.us, cjames@emolecules.com, atri.jiit@gmail.com, sfkeller@gmail.com
Subject: Re: Getting query plan alternatives from query planner?
In-Reply-To: <15381.1395410811@sss.pgh.pa.us>
* 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