Postgres Pro
Downloads
Home   >   mailing lists

Performance & key data type - Mailing list pgsql-sql

From Renato De Giovanni
Subject Performance & key data type
Date
Msg-id 3A66DB28.D667A4F3@viafractal.com.br
Whole thread Raw
List pgsql-sql
Tree view 
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@viafractal.com.br

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: deferred constraints failing on commit
Next
From: Yury Don
Date:
Subject: Re: python+postgresql