Re: Generic design: char vs varchar primary keys

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Generic design: char vs varchar primary keys
Date: 2011-08-05 12:43:48
Message-ID: j1goi4$m5j$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2011-08-04, Raj Mathur (=?utf-8?b?4KSw4KS+4KSc?= =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) <raju(at)linux-delhi(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message ai 2011-08-08 06:53:24 Problem with nested left-joins and coalesce
Previous Message Jasen Betts 2011-08-05 12:40:19 Re: Generic design: char vs varchar primary keys