Re: plan time of MASSIVE partitioning ... - Mailing list pgsql-hackers

From Leonardo Francalanci
Subject Re: plan time of MASSIVE partitioning ...
Date
Msg-id 919158.72344.qm@web29006.mail.ird.yahoo.com
Whole thread Raw
In response to Re: plan time of MASSIVE partitioning ...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> This is going to be dominated by constraint exclusion  checking.  There's
> basically no fix for that except a more explicit  representation of the
> partitioning rules.

Damn, I knew that was going to be more complicated :)

So in which case does this patch help? I guess in a multi-index
scenario? childtables.sql is kind of hard to read (I think a FOR loop
would have been more auto-explaining?).





pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: crash in plancache with subtransactions
Next
From: Tom Lane
Date:
Subject: Re: crash in plancache with subtransactions