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 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. -- ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org