Message-ID: <534C3496.5000409@vmware.com>
Date: Mon, 14 Apr 2014 22:18:46 +0300
From: Heikki Linnakangas <hlinnakangas@vmware.com>
Organization: VMware
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Icedove/24.4.0
MIME-Version: 1.0
To: Stefan Keller <sfkeller@gmail.com>,
 Craig James <cjames@emolecules.com>
CC: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Getting query plan alternatives from query planner?
References: 
 <CAFwQ8rc1brXZX7AACd6-X_H1nZSKvM5fuyb0TTm84kGVmC+chg@mail.gmail.com>
 <CAFcOn2_jq9kbjoQrwzJr0=8PYvgECA5ACvhR-wAvSYu=puH6vg@mail.gmail.com>
In-Reply-To: 
 <CAFcOn2_jq9kbjoQrwzJr0=8PYvgECA5ACvhR-wAvSYu=puH6vg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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