What is faster?

From: "Mihai Gheorghiu" <tanethq(at)earthlink(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: What is faster?
Date: 2001-03-30 14:47:36
Message-ID: 003101c0b928$73f46200$a275f7a5@new6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a short table (10 records) with a primary key column.

What primary key column data type will make search faster: int2 or char?
What about char(n) n=2,3...?
I'm looking for speed, as that search is very frequent.

Thanks,

Mihai Gheorghiu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vilson farias 2001-03-30 14:55:57 Re: enable pl/pgsql in postgres from postgres-server-7.0.3-2 RPM
Previous Message Bruno Wolff III 2001-03-30 14:45:34 Memory Tuning