Re: Optimizer oddness, possibly compounded in 8.1

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Optimizer oddness, possibly compounded in 8.1
Date: 2005-12-03 00:35:04
Message-ID: 4390E838.8080207@rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-12-03 00:37:49 Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
Previous Message Tom Lane 2005-12-03 00:20:09 Re: strange behavior (corruption?) of large production database