Primary Key Performance with INTEGER vs. VARCHAR - Mailing list pgsql-general

From Siah
Subject Primary Key Performance with INTEGER vs. VARCHAR
Date
Msg-id 1185022160.688503.236330@n2g2000hse.googlegroups.com
Whole thread Raw
Responses Re: Primary Key Performance with INTEGER vs. VARCHAR  (Jim Nasby <decibel@decibel.org>)
Re: Primary Key Performance with INTEGER vs. VARCHAR  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
Hi,

Designing my application, I was wondering if having my primary keys
(to be indexed) with VARCHAR brings performance down significantly? My
own test didn't show much difference. Thinking about it though, I'd
guess Integer Indexing should be much quicker and efficient.

I'd appreciate all comments in this regard,
Mike


pgsql-general by date:

Previous
From: "Chris Hoover"
Date:
Subject: Help with date math
Next
From: "Mitchell Vincent"
Date:
Subject: PGInstaller Project