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.