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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: What is the best way to create Primary Key on a large table in Postgresql 9.5?
From: Ravi Tammineni <rtammineni@xxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 18 Aug 2016 21:00:06 +0000

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

Follow-Ups:
- Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?
  - From: Keith
- Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?
  - From: Samed YILDIRIM

Prev by Date: Re: plpgsql.so undefined symbol error in pg_upgrade check
Next by Date: Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?
Previous by thread: plpgsql.so undefined symbol error in pg_upgrade check
Next by thread: Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux