Re: Optimizer in 7.1.1 worse thatn 7.0.3
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgbug@industrialsoftworks.com, pgsql-bugs@postgresql.org
Date: 2001-05-25T22:38:26Z
Lists: pgsql-bugs
pgsql-bugs@postgresql.org writes: > I am hoping that there is a simple omission that keeps the optimizer > from using the transitive literal. PG doesn't compute transitive equality of literals, and never has AFAIK (certainly 7.0.* didn't). I'm not sure what's causing the change in behavior from 7.0 to 7.1, but your theory about it is wrong. Could you make up a self-contained example? regards, tom lane