Postgres Pro
Downloads
Home   >   mailing lists

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

From Ravi Tammineni
Subject What is the best way to create Primary Key on a large table in Postgresql 9.5?
Date
Msg-id BN1PR02MB23134DCFEF3087FA7DAF0EC80150@BN1PR02MB231.namprd02.prod.outlook.com
Whole thread Raw
Responses 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?
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: plpgsql.so undefined symbol error in pg_upgrade check
Next
From: Samed YILDIRIM
Date:
Subject: Re: What is the best way to create Primary Key on a large table in Postgresql 9.5?