Re: Help understand why DELETE is so slow

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Ping Yao <ping(at)optigo(dot)net>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Help understand why DELETE is so slow
Date: 2023-12-01 17:50:49
Message-ID: 0402AB48-55B3-44F2-A8B0-45DB3821602A@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Dec 1, 2023, at 09:47, Ping Yao <ping(at)optigo(dot)net> wrote:
> Can someone help me understand why my simple DELETE query is so slow to run?

Based on the plan, you're running PostgreSQL with the Citus extension, and the delay is in Citus-related code. This is probably a question best directed to either the open-source Citus community, or Microsoft.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-12-01 18:19:28 Re: Query related to pg_dump write to a pipe on a windows client and with compressed format
Previous Message Ping Yao 2023-12-01 17:47:38 Help understand why DELETE is so slow