Kato-san,
On 2018/12/21 15:36, Kato, Sho wrote:
> Hi,
> I want to speed up the creation of UPDATE/DELETE generic plan for tables partitioned into a lot.
>
> Currently, creating a generic plan of UPDATE/DELTE for such table, planner creates a plan to scan all partitions.
> So it takes a very long time.
> I tried with a table partitioned into 8192, it took 12 seconds.
>
> In most cases, since the partitions to access are partial, I think planner does not need to create a Scan path for
everypartition.
What do you mean by "since the partitions to access are partial"?
> Is there any better way? For example, can planner create generic plans from the parameters specified for EXECUTE?
Well, a generic plan is, by definition, *not* specific to the values of
parameters, so it's not clear what you're suggesting here.
Thanks,
Amit