Postgres Pro
Downloads
Home   >   mailing lists

Re: What is the best way to create Primary Key on a large table in Postgresql 9.5? - Mailing list pgsql-admin

From Samed YILDIRIM
Subject Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?
Date
Msg-id 569661471554327@web30h.yandex.ru
Whole thread Raw
In response to What is the best way to create Primary Key on a large table in Postgresql 9.5?  (Ravi Tammineni <rtammineni@partner.aligntech.com>)
Responses Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?  (Ravi Tammineni <rtammineni@partner.aligntech.com>)
List pgsql-admin
Tree view 
<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 by date:

Previous
From: Ravi Tammineni
Date:
Subject: What is the best way to create Primary Key on a large table in Postgresql 9.5?
Next
From: Keith
Date:
Subject: Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?