Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18620: Problem: Slow Delete Operation - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #18620: Problem: Slow Delete Operation
Date
Msg-id CAKFQuwaxWManBizCq6CZpAVJ-z=JRYPJ9JWyE7zsoV4VNpUk3Q@mail.gmail.com
Whole thread Raw
In response to BUG #18620: Problem: Slow Delete Operation  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view
On Monday, September 16, 2024, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      18620
Logged by:          gowtham
Email address:      gowthamraj.kennedykannan@chainsys.com
PostgreSQL version: 15.6
Operating system:   Windows
Description:       

Problem: Slow Delete Operation

Issue: Deleting 4000 records from a parent table is taking more than 1
hour.

Requirement:
Improve the performance of the delete operation without removing the foreign
key constraints.


You can do this yourself - just index the foreign key columns.

David J.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18620: Problem: Slow Delete Operation
Next
From: Tom Lane
Date:
Subject: Re: BUG #18618: pg_upgrade from 14 to 15+ fails for unlogged table with identity column