What to use for GUIDS ?
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
Google for 'postgresql uuid' will reveal some options.
On Mon, Oct 17, 2005 at 09:03:17AM +0100, Paul Newman wrote:
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
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461