Re: Thoughts on how to avoid a massive integer update.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Thoughts on how to avoid a massive integer update.
Дата
Msg-id CAKFQuwYkvURpOY+pJSX53kEfmx6-xzJpLYdT9Au0Ppf3_Q34Wg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Thoughts on how to avoid a massive integer update.  (Rob Sargent <robjsargent@gmail.com>)
Ответы Re: Thoughts on how to avoid a massive integer update.
Список pgsql-general
On Fri, May 8, 2020 at 1:41 PM Rob Sargent <robjsargent@gmail.com> wrote:
My understanding is the keys in the info_table need to change.  That causes the very expensive update in the update in the data tables. No? 

The keys in the info_table need to change because their contents are no longer legal to be stored (OP has not specified but think using an integer value of someones social security number as a key).  The FK side of the relationship equality has the same illegal data values problem and need to be changed too.

David J.

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

Предыдущее
От: Support
Дата:
Сообщение: Re: pg_basebackup cannot compress to STDOUNT
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Thoughts on how to avoid a massive integer update.