Performance & key data type

From: Renato De Giovanni <rdg(at)viafractal(dot)com(dot)br>
To: pgsql-sql(at)postgresql(dot)org
Subject: Performance & key data type
Date: 2001-01-18 12:01:44
Message-ID: 3A66DB28.D667A4F3@viafractal.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

In Postgres, which one should be the best data type to be used as
primary/foreign key considering query performance: INT or CHAR? Is there
any "remarkable" difference between them?

Thank you and regards,
--
Renato
Sao Paulo - SP - Brasil
rdg(at)viafractal(dot)com(dot)br

Browse pgsql-sql by date

  From Date Subject
Next Message Yury Don 2001-01-18 12:11:29 Re: python+postgresql
Previous Message Josh Berkus 2001-01-18 05:54:48 One Question Answered