Re: Proposal to allow DELETE/UPDATE on partitioned tables with unsupported foreign partitions

2025-07-07 Thread Shirisha Shirisha
nks and Regards, Shirisha Broadcom Inc. On Sun, Jul 6, 2025 at 2:34 PM Etsuro Fujita wrote: > On Tue, Jul 1, 2025 at 2:24 AM Shirisha Shirisha > wrote: > > Just wanted to follow up on the patch, any additional feedback or > improvement in the patch would be very helpful. > >

Re: Proposal to allow DELETE/UPDATE on partitioned tables with unsupported foreign partitions

2025-06-30 Thread Shirisha Shirisha
follow up on the patch, any additional feedback or improvement in the patch would be very helpful. Thanks and Regards, Shirisha Broadcom Inc. On Thu, Jun 12, 2025 at 3:59 PM Etsuro Fujita wrote: > Hi, > > On Thu, Jun 12, 2025 at 1:47 PM Shirisha Shirisha > wrote: > > We’d lik

Proposal to allow DELETE/UPDATE on partitioned tables with unsupported foreign partitions

2025-06-11 Thread Shirisha Shirisha
Hello Hackers, We’d like to propose a change to improve DELETE and UPDATE behavior on partitioned tables containing foreign partitions. Currently, DELETE or UPDATE (D/U) on a partitioned table with foreign partitions fails with an error as below, if the FDW does not support the operation:

Redux: Throttle WAL inserts before commit

2024-08-27 Thread Shirisha Shirisha
Hello hackers, This is an attempt to resurrect the thread [1] to throttle WAL inserts before the point of commit. Background: Transactions on commit, wait for replication and make sure WAL is flushed up to commit lsn on standby, when synchronous_commit is on. While commit is a mandatory sync/wa