Re: Optimizer oddness, possibly compounded in 8.1 - Mailing list pgsql-hackers

From Philip Warner
Subject Re: Optimizer oddness, possibly compounded in 8.1
Date
Msg-id 4390E838.8080207@rhyme.com.au
Whole thread Raw
In response to Re: Optimizer oddness, possibly compounded in 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Optimizer oddness, possibly compounded in 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>Is it intentional that your test case omits an analyze on t2?
>

No; my mistake.

>(The larger point that joins of inheritance unions aren't well-planned
>is true, but it's always been true...)

It also seems to have a probkem with unions in views.

Is there anything that can be done about this -- workarounds etc? Any
plans to address it? We've got a couple of places where it's beginning
to bite us due to growth of tables.




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: strange behavior (corruption?) of large production database
Next
From: Joe Conway
Date:
Subject: Re: strange behavior (corruption?) of large production