From: pgsql-hackers-ow...@postgresql.org > [mailto:pgsql-hackers-ow...@postgresql.org] 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? Regards Takayuki Tsunakawa -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers