Re: Left joins and inheritance (table partitioning)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Left joins and inheritance (table partitioning)
Date: 2006-04-05 03:50:12
Message-ID: 23675.1144209012@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2006-04-05 04:12:17 Re: Left joins and inheritance (table partitioning)
Previous Message Rod Taylor 2006-04-05 03:29:42 Left joins and inheritance (table partitioning)