> > So I think we're saying that if the target table is a foreign table or
> > temporary table, it can be regarded as PARALLEL_RESTRICTED, right?
> >
>
> Yes
>
> IMO, PARALLEL_RESTRICTED currently enable parallel select but disable
> parallel insert.
> So, the INSERT only happen in leader worker which seems safe to insert into
> tempory/foreigh table.
>
> In addition, there are some other restriction about parallel select which
> seems can be removed:
>
> 1.- Target table has a parallel-unsafe trigger, index expression, column
> default
> expression or check constraint
> 2.- Target table is a partitioned table with a parallel-unsafe partition
> key
> expression or support function
>
> If the Insert's target table is the type listed above, Is there some reasons
> why we can not support parallel select ?
> It seems only leader worker will execute the trigger and key-experssion
> which seems safe.
> (If I miss something about it, please let me know)
So Sorry, please ignore the above, I think of something wrong.
Best regards,
houzj