Re: Delete Enhancement Request - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Delete Enhancement Request
Date
Msg-id CAKFQuwYCdDxwDh6yK98PLs3jewVb5zdDWE3J2sS-3qZh5KTEmg@mail.gmail.com
Whole thread Raw
In response to Delete Enhancement Request  ("Campbell, Lance" <lance@illinois.edu>)
Responses Re: Delete Enhancement Request  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Mon, Jan 14, 2019 at 8:18 AM Campbell, Lance <lance@illinois.edu> wrote:
> Use Case:
> When deleting a large number of records with constraints and triggers PostgreSQL is exceptionally slow.

You may wish to provide an explicit situation that you are
experiencing so that others may offer their experienced insights as to
whether you could be doing anything different to increase the speed of
your deletes or techniques to batch them yourself.

I fail to comprehend how "ability to abort deleting mid-stream and not
lose any progress" is a solution to "deleting...is exceptionally slow"
- its more likely your proposed feature would increase the total time
spent performing the full delete.

David J.


pgsql-admin by date:

Previous
From: Paul Carlucci
Date:
Subject: Re: Delete Enhancement Request
Next
From: Tom Lane
Date:
Subject: Re: Delete Enhancement Request