On Tue, 2006-04-04 at 23:50 -0400, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> 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 plann
Rod Taylor <[EMAIL PROTECTED]> 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 sequent
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.
The second i
