list number of entries to be delete in cascading deletes

Поиск
Список
Период
Сортировка
От Eildert Groeneveld
Тема list number of entries to be delete in cascading deletes
Дата
Msg-id 1392152044.4823.9.camel@localhost
обсуждение исходный текст
Ответ на Re: Strange performance boost with random()  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: list number of entries to be delete in cascading deletes
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Strange performance boost with random()
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: list number of entries to be delete in cascading deletes