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?
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
pgsql-admin by date
|Next:||From: Nick Fankhauser||Date: 2002-04-15 19:20:06|
|Subject: Re: string PK vs. interger PK|
|Previous:||From: Neil Conway||Date: 2002-04-15 18:24:51|
|Subject: Re: Alter/update large tables - VERRRY annoying behaviour!|