Optimizer problems

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: hackers(at)postgreSQL(dot)org (PostgreSQL-development)
Subject: Optimizer problems
Date: 1999-02-08 18:23:42
Message-ID: 199902081823.NAA16833@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I am fixing p_ordering(now called path_order) to properly display in
outNode/readNode and friends.

This structure is never output during debug runs. Without the display,
it is hard to see if the optimizer is doing what it should.

My suspicion is that RelOptInfo is retaining many duplicate pathlist
Path's that have duplicate/useless PathOrder/key combinations, causing
optimization of large queries to be very slow.

I'll keep going.

Is it me, or have things gotten very busy in the last week on the
hackers list, with tons of new features coming in?

--
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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 1999-02-08 18:53:55 Re: [HACKERS] DEC OSF1 Compilation problems
Previous Message Bruce Momjian 1999-02-08 18:15:09 Re: [HACKERS] Keywords