Postgres Pro
Downloads
Home   >   mailing lists

Re: Generic design: char vs varchar primary keys - Mailing list pgsql-sql

From Jasen Betts
Subject Re: Generic design: char vs varchar primary keys
Date
Msg-id j1goi4$m5j$2@reversiblemaps.ath.cx
Whole thread Raw
In response to Generic design: char vs varchar primary keys  ("Raj Mathur (राज माथुर)" <raju@linux-delhi.org>)
List pgsql-sql
Tree view 
On 2011-08-04, Raj Mathur (राज माथुर) <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

pgsql-sql by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Generic design: char vs varchar primary keys
Next
From: "ai"
Date:
Subject: Problem with nested left-joins and coalesce