Re: Optimizer in 7.1.1 worse thatn 7.0.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgbug(at)industrialsoftworks(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Optimizer in 7.1.1 worse thatn 7.0.3
Date: 2001-05-25 22:38:26
Message-ID: 14281.990830306@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Panon, Paul-Andre 2001-05-26 01:06:48 SQL update statements are failing if submitted in sequence on sam e connection
Previous Message Arcady Genkin 2001-05-25 20:54:11 Compilation --with-python fails on Solaris 8