Re: Constraint Exclusion on all tables - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Constraint Exclusion on all tables
Date
Msg-id 1121814963.3998.42.camel@localhost.localdomain
Whole thread Raw
In response to Re: Constraint Exclusion on all tables  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: Constraint Exclusion on all tables
List pgsql-hackers
On Tue, 2005-07-19 at 17:50 -0500, Jim C. Nasby wrote:
> On Tue, Jul 19, 2005 at 10:23:49PM +0100, Simon Riggs wrote:
> > Inheritance queries would continue to act as they do now, where an
> > excluded table is *not* shown; this is to allow for sensible size
> > EXPLAINs when we have 100s of child tables.
> 
> Since it's also possible to do partitioning with UNION ALL, maybe it
> would be better if there was an option to explain that told it either to
> show or not show info about eliminated partitions. That would seem to
> serve the general case better than coding it according to table type.

Can you think up the syntax, so we can comment on that proposal?

Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [PATCHES] Patch to fix plpython on OS X
Next
From: Michael Fuhr
Date:
Subject: Re: [PATCHES] Patch to fix plpython on OS X