What to use for GUIDS ?

From: "Paul Newman" <pnewman(at)tripoint(dot)co(dot)uk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: What to use for GUIDS ?
Date: 2005-10-17 08:03:17
Message-ID: D5F7521105A39145BEA6A6F47AEFFA88291530@sbserver.tripoint.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We are using GUIDS as primary keys. At the moment we're using a varchar
32. We'd like to use varchar 16 but had some problems with the generated
chars; we were using UNICODE locale (we're now using WIN1251). Should we
use bytea, retry varchar 16 (with the new local), or some other column
type ?? What is going to give us the best performance (with 8.1) ?

Thank You

Paul Newman

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-10-17 08:34:57 Re: Safe to kill idle connections?
Previous Message Sri 2005-10-17 07:10:01 Problem using start transaction in nested transactions.