Re: query plan in pg7.4 vs 8.0.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: query plan in pg7.4 vs 8.0.3
Date
Msg-id 20826.1119020230@sss.pgh.pa.us
Whole thread Raw
In response to Re: query plan in pg7.4 vs 8.0.3  (Albert Vernon Smith <contact1@absentia.com>)
List pgsql-general
Albert Vernon Smith <contact1@absentia.com> writes:
> I just re-checked, and all the same index definitions are on both
> tables.

Well, that seems to imply that the 8.0 planner is missing the plan that
7.4 finds ... which is both hard to believe and impossible to
investigate with this much info.  Would it be possible to get a copy of
the database?  Or at least a schema dump?

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Change to make strings SQL-standard
Next
From: Doug Bloebaum
Date:
Subject: Re: Viewing non-system objects in psql