| From: | Samed YILDIRIM <samed(at)reddoc(dot)net> |
|---|---|
| To: | Ravi Tammineni <rtammineni(at)partner(dot)aligntech(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: What is the best way to create Primary Key on a large table in Postgresql 9.5? |
| Date: | 2016-08-18 21:05:27 |
| Message-ID: | 569661471554327@web30h.yandex.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)partner(dot)aligntech(dot)com">rtammineni(at)partner(dot)aligntech(dot)com</a>>:</p><blockquote> 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.<br /><br /> Thanks<br /><br /> ravi</blockquote>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 665 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith | 2016-08-18 21:14:36 | Re: What is the best way to create Primary Key on a large table in Postgresql 9.5? |
| Previous Message | Ravi Tammineni | 2016-08-18 21:00:06 | What is the best way to create Primary Key on a large table in Postgresql 9.5? |