Joel Jacobson <joel@xxxxxxxxxxxxxxx> writes: > Hm, it is strange the query planner is using two different strategies > for the same query? They're not the same query. One plan is generic for any value of the parameters, the other is chosen for specific values of those parameters. In particular, the unparameterized query depends very strongly on the knowledge that not many rows will meet the RecordDate range constraint. If you picked dates that were further apart you'd probably get something that looked more like the other plan. 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
