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