What is the best way to create Primary Key on a large table in Postgresql 9.5?

Поиск
Список
Период
Сортировка
От Ravi Tammineni
Тема What is the best way to create Primary Key on a large table in Postgresql 9.5?
Дата
Msg-id BN1PR02MB23134DCFEF3087FA7DAF0EC80150@BN1PR02MB231.namprd02.prod.outlook.com
обсуждение исходный текст
Ответы Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?  (Samed YILDIRIM <samed@reddoc.net>)
Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?  (Keith <keith@keithf4.com>)
Список pgsql-admin
Дерево обсуждения

I have to create a primary key on a large table (~100Million records). What is the best and fastest way to create pkey? This column is a sequence column and i don't want to lock the table because this is highly transactional database.

 

Thanks

ravi

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: plpgsql.so undefined symbol error in pg_upgrade check
Следующее
От: Samed YILDIRIM
Дата:
Сообщение: Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?