Search Postgresql Archives

guids / bytea and index use ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

We are currently using a 32byte varchar for our primary keys. We tried to reduce this down to 16 bytes but varchar didn’t seem to store this correctly. I’d like to use bytea instead so we could use 16bytes, but are indexes used properly ? Does anyone have any other suggestions on how to store guids ? We don’t have any experience in recompiling the postgres source code etc.

 

Thanks

 

Paul Newman


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux