Postgres Pro
Downloads
Home   >   mailing lists

Re: Help understand why DELETE is so slow - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Help understand why DELETE is so slow
Date
Msg-id 0402AB48-55B3-44F2-A8B0-45DB3821602A@thebuild.com
Whole thread Raw
In response to Help understand why DELETE is so slow  (Ping Yao <ping@optigo.net>)
List pgsql-general
Tree view 

> On Dec 1, 2023, at 09:47, Ping Yao <ping@optigo.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
probablya question best directed to either the open-source Citus community, or Microsoft.

pgsql-general by date:

Previous
From: Ping Yao
Date:
Subject: Help understand why DELETE is so slow
Next
From: Tom Lane
Date:
Subject: Re: Query related to pg_dump write to a pipe on a windows client and with compressed format