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(at)absentia(dot)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
>