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

Re: [HACKERS] optimizer cleanup

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: lockhart(at)alumni(dot)caltech(dot)edu (Thomas G(dot) Lockhart)
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] optimizer cleanup
Date: 1999-02-22 16:42:01
Message-ID: 199902221642.LAA29460@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> > I have completed most of the cleanups I want to do with the optimizer.
> > It is much improved.
> > It passes the regression tests.
> 
> Are you seeing misc.sql pass in the regression test? I've got a tree
> which is a few days old, but four warnings of the form:
> 
>   NOTICE:  Non-functional update, only first update is performed
> 
> have disappeared. I'm worried that there might be some query analysis
> which is no longer happening...

misc fails here with those missing warnings, but the warnings have not
been here in a long time.  My regression test logs go back to Jan 29,
and at that time the warning lines where missing too.

It is an UPDATE with a join that caused the old warnings.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist(at)candle(dot)pha(dot)pa(dot)us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1999-02-22 16:46:59
Subject: Re: [HACKERS] large objects failing (hpux10.20 sparc/solaris 2.6, gcc 2.8.1)
Previous:From: Bruce MomjianDate: 1999-02-22 16:37:57
Subject: Re: start on outer join

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