> [] On Behalf Of Alexander
> Korotkov
> Yes. Getting at least some of this features committed to v10 would be great
> and improve partitioning usability a lot.

I'm sorry for not contributing to the real partitioning feature, but I'm really 
looking forward to seeing the efficient plan-time and run-time partition 
pruning implemented in v10.  Recently, we failed to acquire a customer because 
they could not achieve their performance goal due to the slow partition pruning 
compared to Oracle.  The batch app prepares a SELECT statement against a 
partitioned table, then executes it millions of time with different parameter 
values.  It took a long time to process Bind messages.

Another requirement was subpartitioning.  Will this be possible with the 
current infrastructure, or does this need drastic change?

Takayuki Tsunakawa

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

Reply via email to