Re: Left joins and inheritance (table partitioning)

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.

--

In response to

Browse pgsql-hackers by date

  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)