Re: query plan in pg7.4 vs 8.0.3

I just re-checked, and all the same index definitions are on both
tables.

Cheers,
-albert

On 17.6.2005, at 14:20, Tom Lane wrote:

> Albert Vernon Smith <contact1@absentia.com> writes:
>
>> I am in process of migrating a database from Pg 7.4.3 to Pg 8.0.3.  I
>> dumped and reloaded the data, and things look good, until I try to
>> work with it.  When I try to make a query to a view based on a large
>> join (select * from 'view' limit 10), the 7.4.3 query works very
>> well, and the indexes are being used well.  But, when I go to 8.0.3,
>> there are some very costly joins, and the query is not workable.
>>
>
> Are you sure you have all the same indexes in the 8.0 database?  It
> looks like one might be missing on assay2rs.assay_id.
>
>             regards, tom lane
>