Postgres Pro
Downloads
Home   >   mailing lists

Re: Left joins and inheritance (table partitioning) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Left joins and inheritance (table partitioning)
Date
Msg-id 23675.1144209012@sss.pgh.pa.us
Whole thread Raw
In response to Left joins and inheritance (table partitioning)  (Rod Taylor <pg@rbt.ca>)
Responses Re: Left joins and inheritance (table partitioning)  (Rod Taylor <pg@rbt.ca>)
List pgsql-hackers
Tree view 
Rod Taylor <pg@rbt.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

pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Left joins and inheritance (table partitioning)
Next
From: Rod Taylor
Date:
Subject: Re: Left joins and inheritance (table partitioning)