Quick Links

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

From:	Ravi Tammineni <rtammineni(at)partner(dot)aligntech(dot)com>
To:	"pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject:	What is the best way to create Primary Key on a large table in Postgresql 9.5?
Date:	2016-08-18 21:00:06
Message-ID:	BN1PR02MB23134DCFEF3087FA7DAF0EC80150@BN1PR02MB231.namprd02.prod.outlook.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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

Responses

Re: What is the best way to create Primary Key on a large table in Postgresql 9.5? at 2016-08-18 21:05:27 from Samed YILDIRIM
Re: What is the best way to create Primary Key on a large table in Postgresql 9.5? at 2016-08-18 21:14:36 from Keith

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Samed YILDIRIM	2016-08-18 21:05:27	Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?
Previous Message	Tom Lane	2016-08-18 20:09:33	Re: plpgsql.so undefined symbol error in pg_upgrade check