| 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: | Postg롤 토토SQL : |
>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.
| 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 |