What to use for GUIDS ? - Mailing list pgsql-general

From Paul Newman
Subject What to use for GUIDS ?
Date
Msg-id D5F7521105A39145BEA6A6F47AEFFA88291530@sbserver.tripoint.local
Whole thread Raw
Responses Re: What to use for GUIDS ?  ("Jim C. Nasby" <jnasby@pervasive.com>)
List 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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Safe to kill idle connections?
Next
From: "Sri"
Date:
Subject: Problem using start transaction in nested transactions.