Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?
| От | Samed YILDIRIM |
|---|---|
| Тема | Re: What is the best way to create Primary Key on a large table in Postgresql 9.5? |
| Дата | |
| Msg-id | 569661471554327@web30h.yandex.ru обсуждение исходный текст |
| Ответ на | What is the best way to create Primary Key on a large table in Postgresql 9.5? (Ravi Tammineni <rtammineni@partner.aligntech.com>) |
| Ответы |
Re: What is the best way to create Primary Key on a large
table in Postgresql 9.5?
Re: What is the best way to create Primary Key on a large table in Postgresql 9.5? |
| Список | pgsql-admin |
<p>Hi Ravi,<br /><br />You can use CREATE INDEX with CONCURRENTLY keyword. It will not lock your table during the process.<br/><br />Best regards.<br /><br /><br /><br />İyi çalışmalar.<br />Samed YILDIRIM<br /><br /><br />19.08.2016,00:01, "Ravi Tammineni" <<a href="mailto:rtammineni@partner.aligntech.com">rtammineni@partner.aligntech.com</a>>:<blockquote> Ihave to create a primarykey on a large table (~100Million records). What is the best and fastest way to create pkey? This column is a sequencecolumn and i don't want to lock the table because this is highly transactional database.<br /><br /> Thanks<br /><br/> ravi</blockquote>
В списке pgsql-admin по дате отправления: