Re: Getting query plan alternatives from query planner? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Getting query plan alternatives from query planner?
Date
Msg-id 15381.1395410811@sss.pgh.pa.us
Whole thread Raw
In response to Re: Getting query plan alternatives from query planner?  (Craig James <cjames@emolecules.com>)
List pgsql-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


pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Re: Getting query plan alternatives from query planner?
Next
From: Guillaume Smet
Date:
Subject: Connection pooling - Number of connections