Postgres Pro
Downloads
Home   >   mailing lists

string PK vs. interger PK - Mailing list pgsql-admin

From Jodi Kanter
Subject string PK vs. interger PK
Date
Msg-id 019201c1e4af$3b855c90$de138f80@virginia.edu
Whole thread Raw
Responses Re: string PK vs. interger PK  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-admin
Tree view
Can anyone offer some insight as to what should be considered when choosing between a primary key that is an integer vs. a primary key that is a string value? Does one or the other affect indexing speed? update speed?
Is a serial integer value better than using a PK that has some "value" in its meaning but is a string?
Thanks
Jodi

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu

 

 

 

pgsql-admin by date:

Previous
From: "Peter Darley"
Date:
Subject: Re: ODBC Problem
Next
From: "Nick Fankhauser"
Date:
Subject: Re: string PK vs. interger PK