Re: WIP: cross column correlation ...
Josh Berkus <josh@agliodbs.com>
From: Josh Berkus <josh@agliodbs.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: PostgreSQL - Hans-Jürgen Schönig <postgres@cybertec.at>, pgsql-hackers Hackers <pgsql-hackers@postgresql.org>, Boszormenyi Zoltan <zb@cybertec.at>
Date: 2011-02-24T01:09:10Z
Lists: pgsql-hackers
> Personally, I think the first thing we ought to do is add a real, bona
> fide planner hint to override the selectivity calculation manually,
> maybe something like this:
>
> WHERE (x < 5 AND y = 1) SELECTIVITY (0.1);
>
> Then, having provided a method for the DBA to extinguish the raging
> flames of searing agony which are consuming them while a crocodile
> chews off their leg and their boss asks them why they didn't use
> Oracle, we can continue bikeshedding about the best way of fixing this
> problem in a more user-transparent fashion.
Is there some way we can do that without adding the selectivity hint to
the query itself? That's the biggest issue with hints.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com