GENERATED STORED columns and table rewrites?

Поиск
Список
Период
Сортировка
От Maciek Sakrejda
Тема GENERATED STORED columns and table rewrites?
Дата
Msg-id CAOtHd0BMw1A58d35DjWj5jScbmcoF1heGbBz_WV7kd2fU92cKg@mail.gmail.com
обсуждение исходный текст
Ответы Re: GENERATED STORED columns and table rewrites?  (Michael Lewis <mlewis@entrata.com>)
Список pgsql-general
Hello,

Does adding a GENERATED STORED column need to rewrite the table (like adding a column with a DEFAULT before 11)? Neither the ALTER TABLE docs [1] nor the generated column docs [2] discuss this. The former has a very nice Tip regarding DEFAULT columns--maybe we should clarify GENERATED STORED behavior either way? It seems like a very similar issue. Experimenting with this, \timing suggests that there is work proportional to the size of the table, but I'd like to understand the behavior better (and other users probably would, too).

Thanks,

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_basebackup && long time storage of wal_archive/ content
Следующее
От: Niels Jespersen
Дата:
Сообщение: timestamp and timestamptz