Re: Most effective settings for deleting lots of data?

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Most effective settings for deleting lots of data?
Дата
Msg-id 55DE2A4A.1070201@gmail.com
обсуждение исходный текст
Ответ на Re: Most effective settings for deleting lots of data?  (Alan Hodgson <ahodgson@simkin.ca>)
Список pgsql-general
On 08/26/2015 02:34 PM, Alan Hodgson wrote:
On Wednesday, August 26, 2015 08:25:02 PM Cory Tucker wrote:
What settings would you recommend?  Also, it just occurred to me that I
should try to disable/drop all indexes (especially since they will be
recreated) later so that those are not updated in the process.
Don't drop the indexes your foreign keys use to find cascading deletes.



Or do drop indexes and walk up your dependency graph manually.

В списке pgsql-general по дате отправления:

Предыдущее
От: Alan Hodgson
Дата:
Сообщение: Re: Most effective settings for deleting lots of data?
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Grouping sets, cube and rollup