csmith <csmith@xxxxxxxxxxxxxxxxx> writes: > ... It's as if the > query is considering tuples in "catalog" outside of the view's domain. This isn't particularly surprising: the planner will feel free to push that WHERE condition down as far as it can. Probably there is some aspect of the view definition that prevented such an optimization in prior versions but doesn't deter 8.3. You didn't show us the view though, nor any EXPLAIN output ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general