Postgres Pro
Downloads
Home   >   mailing lists

list number of entries to be delete in cascading deletes - Mailing list pgsql-performance

From Eildert Groeneveld
Subject list number of entries to be delete in cascading deletes
Date
Msg-id 1392152044.4823.9.camel@localhost
Whole thread Raw
In response to Re: Strange performance boost with random()  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: list number of entries to be delete in cascading deletes  (Claudio Freire <klaussfreire@gmail.com>)
List pgsql-performance
Tree view 
Dear All

this probably not the best list to post this question:

I use cascading deletes but would like to first inform the user what she
is about to do.
Something like : explain delete from PANEL where panel_id=21;
-- you are about to delete 32144 records in tables abc aaa wewew

This is clearly something that can be programmed but as all information
is available in the database schema, there should be a generalized
procedure available.

Is there someone who has heard about this problem?

greetings

Eildert

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange performance boost with random()
Next
From: Claudio Freire
Date:
Subject: Re: list number of entries to be delete in cascading deletes