Postgres Pro
Downloads
Home   >   mailing lists

What is faster? - Mailing list pgsql-general

From Mihai Gheorghiu
Subject What is faster?
Date
Msg-id 003101c0b928$73f46200$a275f7a5@new6
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: Memory Tuning
Next
From: Eric Frazier
Date:
Subject: Re: [JDBC] Logging Queries