Re: What to use for GUIDS ?
| От | Jim C. Nasby |
|---|---|
| Тема | Re: What to use for GUIDS ? |
| Дата | |
| Msg-id | 20051017181049.GC86144@pervasive.com обсуждение исходный текст |
| Ответ на | What to use for GUIDS ? ("Paul Newman" <pnewman@tripoint.co.uk>) |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: