Re: partition pruning only works for select but update

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: partition pruning only works for select but update
Date: 2022-06-28 13:30:00
Message-ID: 2391513.1656423000@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"James Pang (chaolpan)" <chaolpan(at)cisco(dot)com> writes:
> But when
> Explain update table set .. where partitionkey between to_timestamp() and to_timestamp();
> It still show all of partitions with update ...

In releases before v14, partition pruning is far stupider for UPDATE
(and DELETE) than it is for SELECT.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message James Pang (chaolpan) 2022-06-28 13:34:18 RE: partition pruning only works for select but update
Previous Message James Pang (chaolpan) 2022-06-28 13:15:42 partition pruning only works for select but update