Re: query plan in pg7.4 vs 8.0.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Albert Vernon Smith <contact1(at)absentia(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: query plan in pg7.4 vs 8.0.3
Date: 2005-06-17 14:57:10
Message-ID: 20826.1119020230@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Albert Vernon Smith <contact1(at)absentia(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-06-17 14:58:30 Change to make strings SQL-standard
Previous Message Gavin Love 2005-06-17 14:52:34 Re: Backing up multiple databases