From: Heikki Linnakangas <hlinnakangas@vmware.com>
To: Stefan Keller <sfkeller@gmail.com>
To: Craig James <cjames@emolecules.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Getting query plan alternatives from query planner?
Date: Mon, 14 Apr 2014 22:18:46 +0300
Message-ID: <534C3496.5000409@vmware.com> (raw)
In-Reply-To: <CAFcOn2_jq9kbjoQrwzJr0=8PYvgECA5ACvhR-wAvSYu=puH6vg@mail.gmail.com>
References: <CAFwQ8rc1brXZX7AACd6-X_H1nZSKvM5fuyb0TTm84kGVmC+chg@mail.gmail.com>
<CAFcOn2_jq9kbjoQrwzJr0=8PYvgECA5ACvhR-wAvSYu=puH6vg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 04/14/2014 09:36 PM, Stefan Keller wrote:
> Who's the elephant in the room who is reluctant to introduce explicit hints?
Please read some of the previous discussions on this. Like this, in this
very same thread:
http://www.postgresql.org/message-id/15381.1395410811@sss.pgh.pa.us
I'd like to have explicit hints, *of the kind explained in that
message*. Hints that tell the planner what the data distribution is
like. Hints to override statistics and heuristics used by the planner.
- Heikki
--
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: hlinnakangas@vmware.com, sfkeller@gmail.com, cjames@emolecules.com
Subject: Re: Getting query plan alternatives from query planner?
In-Reply-To: <534C3496.5000409@vmware.com>
* 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