Thread: 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