From: Jasen Betts <jasen@xnet.co.nz>
To: pgsql-sql@postgresql.org
Subject: Re: Generic design: char vs varchar primary keys
Date: 5 Aug 2011 12:43:48 GMT
Message-ID: <j1goi4$m5j$2@reversiblemaps.ath.cx> (raw)
References: <201108032040.17628.raju@linux-delhi.org>
<CAK3UJREnef=j-2RPZQ1pn_68EE_x7cRKVbTavPOCLZTN_jqN9A@mail.gmail.com>
<201108040728.26315.raju@linux-delhi.org>
On 2011-08-04, Raj Mathur (=?utf-8?b?4KSw4KS+4KSc?= =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) <raju@linux-delhi.org> wrote:
> Thanks, that's useful for benchmarking the various textual data types.
> Anything specific about using CHAR vs VARCHAR for primary keys that are
> going to be referenced from multiple tables that comes to mind?
that page he pointed you to says they are all stored the same.
(excepte char(8) is padded and that may bloat the index a bit)
--
⚂⚃ 100% natural
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasen@xnet.co.nz
Subject: Re: Generic design: char vs varchar primary keys
In-Reply-To: <j1goi4$m5j$2@reversiblemaps.ath.cx>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox