Eddy Escardo-Raffo <eescardo@xxxxxxxxxx> writes: > For C, the planner estimated 10 thousand rows. For D, the planner estimated > 100 thousand rows, yet for E the planner estimated only 1 row, which is the > closest to reality. So, is there any way to specify a query that has a > SUB-SELECT that returns a small set of values so that the planner treats it > similar to how it treats statement E, or does statement E get its additional > edge precisely from the fact that the restriction is defined by integer > literals? Currently there is no attempt to look at the exact contents of a VALUES construct for planning purposes. For the examples you're showing it seems like the IN (list) notation is more compact and more widely used, so improving the VALUES alternative doesn't seem that exciting. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
