Re: Add column with default value in big table - splitting ofupdates can help?

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Add column with default value in big table - splitting ofupdates can help?
Дата
Msg-id 20200130162021.GA29421@depesz.com
обсуждение исходный текст
Ответ на Add column with default value in big table - splitting of updates can help?  (Durumdara <durumdara@gmail.com>)
Ответы Re: Add column with default value in big table - splitting of updatescan help?
Список pgsql-general
On Thu, Jan 30, 2020 at 04:51:02PM +0100, Durumdara wrote:
> Is there any advance when I split updates? I'm in one transaction.

In this case - no. The benefit of split updates is when you're not in
single transaction.

Why would you want to have it all done in single transaction?

Best regards,

depesz




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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Add column with default value in big table - splitting of updatescan help?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Exclude constraint on ranges : commutative containment : allowonly complete containment