On Fri, Jul 21, 2017 at 11:54 AM, Rafia Sabih <rafia.sa...@enterprisedb.com> 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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
