| From: | Rod Taylor <pg(at)rbt(dot)ca> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Left joins and inheritance (table partitioning) |
| Date: | 2006-04-05 04:12:17 |
| Message-ID: | 1144210337.856.300.camel@home |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 2006-04-04 at 23:50 -0400, Tom Lane wrote:
> Rod Taylor <pg(at)rbt(dot)ca> writes:
> > I've recently been playing with table partitioning limitations. Turning
> > over a large volume of data in inherited structures in a live
> > environment, and have run into a couple of snags in the planner.
>
> > The first is that LEFT JOIN will always do a sequential scan on all
> > inherited tables.
>
> Try it in CVS HEAD.
Indeed, much better.
Sorry about the noise.
--
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2006-04-05 04:16:05 | Summer of Code Preparation |
| Previous Message | Tom Lane | 2006-04-05 03:50:12 | Re: Left joins and inheritance (table partitioning) |