Re: Best way to delete big amount of records from big table
От
Laurenz Albe
Тема
Re: Best way to delete big amount of records from big table
Дата
Msg-id
ec48ca143f128cbd2b8202338c3122f3c01078b6.camel@cybertec.at
Ответ на
Re: Best way to delete big amount of records from big table (Ekaterina Amez)
Список
Дерево обсуждения
Best way to delete big amount of records from big table Ekaterina Amez <ekaterina.amez@zunibal.com>
Re: Best way to delete big amount of records from big table Laurenz Albe <laurenz.albe@cybertec.at>
Re: Best way to delete big amount of records from big table Ekaterina Amez <ekaterina.amez@zunibal.com>
Re: Best way to delete big amount of records from big table Laurenz Albe <laurenz.albe@cybertec.at>
Re: Best way to delete big amount of records from big table Michael Lewis <mlewis@entrata.com>
Re: Best way to delete big amount of records from big table Justin Pryzby <pryzby@telsasoft.com>
Re: Best way to delete big amount of records from big table Ekaterina Amez <ekaterina.amez@zunibal.com>
Re: Best way to delete big amount of records from big table Ekaterina Amez <ekaterina.amez@zunibal.com>
Re: Best way to delete big amount of records from big table Rick Otten <rottenwindfish@gmail.com>
On Fri, 2020-03-27 at 16:15 +0100, Ekaterina Amez wrote: > > You should define primary and foreign keys if you can, but I guess > > I don't have to tell you that. > > Excuse me if this is a silly question but I've read (or understood) that it's better > to remove constraints to improve delete performance... this is related to indexes only? or also to PK-FK? I meant, add constraints *after* you are done cleaning up. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
В списке pgsql-performance по дате отправления
