Received: from rush.u-netsys.com.br (rush.u-netsys.com.br [200.192.48.10]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0IBtF043983 for ; Thu, 18 Jan 2001 06:55:16 -0500 (EST) (envelope-from rdg@viafractal.com.br) Received: (qmail 23254 invoked from network); 18 Jan 2001 11:55:03 -0000 Received: from ppp48-pm3.u-netsys.com.br (HELO viafractal.com.br) (200.192.49.177) by rush.u-netsys.com.br with SMTP; 18 Jan 2001 11:55:03 -0000 Message-ID: <3A66DB28.D667A4F3@viafractal.com.br> Date: Thu, 18 Jan 2001 10:01:44 -0200 From: Renato De Giovanni X-Mailer: Mozilla 4.72 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Performance & key data type Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/212 X-Sequence-Number: 877 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