On Wed, 2008-09-10 at 07:13 -0400, Robert Haas wrote: > >> I'm not planner guru but it seems to me that BETWEEN clause could be > >> rewritten as a IN clause for integer data types and small interval. > > > > Where should the line be drawn. > > Define small :) > > When the estimated cost is lower?
You still need to draw a line for when to even try estimating the cost . Will this be interval of 10 ? or 100 ? or 10000 ? ---------------- Hannu -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers