Re: Optimizer oddness, possibly compounded in 8.1
Philip Warner <pjw@rhyme.com.au>
From: Philip Warner <pjw@rhyme.com.au>
To: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgreSQL.org
Date: 2005-12-03T00:35:04Z
Lists: 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.