Primary Key Performance with INTEGER vs. VARCHAR

From: Siah <siasookhteh(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Primary Key Performance with INTEGER vs. VARCHAR
Date: 2007-07-21 12:49:20
Message-ID: 1185022160.688503.236330@n2g2000hse.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zlatko Matić 2007-07-21 20:24:38 encodings
Previous Message Nis Jørgensen 2007-07-21 11:50:32 Re: Foreign key constraint question