Re: Postgresql tuning..
Started by dimaover 23 years ago2 messagesgeneral
what would be faster on SELECT and UPDATE query...
a table with a varchar as a primary key or an int primary keyed column..
varchar primary keys are always slower
Import Notes
Reference msg id not found: 200208290711.g7T7BjU43660@gmanewmedia.com
would it make a difference if ill be using an 12 digit primary key compared
to a 12 chars primary keyed table....
difference in terms of speed/performance from a select and update queries...
TIA
Show quoted text
On Thursday 29 August 2002 03:30, you wrote:
what would be faster on SELECT and UPDATE query...
a table with a varchar as a primary key or an int primary keyed column..varchar primary keys are always slower
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?