Adding a not null constraint faster

Поиск
Список
Период
Сортировка
От Joe Van Dyk
Тема Adding a not null constraint faster
Дата
Msg-id CACfv+p+-mPNrz40FNxMFMTEDnsjb4o3XN8216xnogeSbhpr5hQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Adding a not null constraint faster
Список pgsql-general
Is there a way to add a NOT NULL constraint to a column without having
to lock the table while a sequential read happens?

Seems like it should be possible to add an index on the column for
null values, like:
create index on t using btree(col_name) where col_name is null;

Then when adding the not null constraint, pg could lock the table, use
that index to see if there's any nulls, and if there's not, add the
constraint.

(That's not possible already, right? I couldn't figure it out if it was.)

Right now, the strategy for adding a not null constraint to a column
without any significant downtime involves creating a new table, as I
understand it.

Joe


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

Предыдущее
От: patrick keshishian
Дата:
Сообщение: Re: pg_query_params() problem with date_trunc() (possibly other functions as well)
Следующее
От: Thomas Kellerer
Дата:
Сообщение: 9.4 beta - pg_get_viewdef() and WITH CHECK OPTION