Albert Vernon Smith <[EMAIL PROTECTED]> 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. Wo
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 <[EMAIL PROTECTED]> 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 l
Albert Vernon Smith <[EMAIL PROTECTED]> 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' limi
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 indexe
