| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | "gowthamraj(dot)kennedykannan(at)chainsys(dot)com" <gowthamraj(dot)kennedykannan(at)chainsys(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #18620: Problem: Slow Delete Operation |
| Date: | 2024-09-16 19:51:36 |
| Message-ID: | CAKFQuwaxWManBizCq6CZpAVJ-z=JRYPJ9JWyE7zsoV4VNpUk3Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Monday, September 16, 2024, PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:
> The following bug has been logged on the website:
>
> Bug reference: 18620
> Logged by: gowtham
> Email address: gowthamraj(dot)kennedykannan(at)chainsys(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2024-09-16 21:11:09 | Re: BUG #18618: pg_upgrade from 14 to 15+ fails for unlogged table with identity column |
| Previous Message | Francesco Degrassi | 2024-09-16 19:35:13 | Leader backend hang on IPC/ParallelFinish when LWLock held at parallel query start |