On Fri, Jul 21, 2017 at 11:54 AM, Rafia Sabih <[email protected]> wrote: > So, does this > also mean that a partitioned table will not join with an unpartitioned > table without append of partitions? >
Yes. When you join an unpartitioned table with a partitioned table, the planner will choose to append all the partitions of the partitioned table and then join with the unpartitioned table. -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
