Hello, On 2015-08-30 PM 10:42, My Life wrote: > > For partitioned table's scan action, and JOIN action, we implemented > a plan node named 'PartitionExpand'. the plan node can expand the > partitioned table scan node into a list of partitions according to > the filter and conditions. and it can expand partitioned table JOIN > node into a list of partitions JOIN node wisely. > We implemented a DynamicPrunePartition method, which can expand the > partitioned table's scan node into a list of partition's scan node. > We implemented a DynamicPrunePartitionJoin method, which can expand > the partitioned table's JOIN node into a list of partition's JOIN node. > These expand action happend in ExecInitPartitionExpand function, when > initialize the executor. and all these action implemented based on the > partition catalog. >
In your design, can index scan be used for individual partition? If yes, can you share how it is handled? Thanks, Amit -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers