Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group