varchar as primary key

Поиск
Список
Период
Сортировка
От Matthew Hixson
Тема varchar as primary key
Дата
Msg-id F90BB4FF-6F32-4A56-A6F4-429505850CAB@poindextrose.org
обсуждение исходный текст
Ответы Re: varchar as primary key  (William Garrison <postgres@mobydisk.com>)
Re: varchar as primary key  (Jeff Davis <pgsql@j-davis.com>)
Re: varchar as primary key  ("Alexander Staubo" <alex@purefiction.net>)
Список pgsql-general
I'm investigating the usage of a UUID primary key generator using
Hibernate and Postgres.  The reason for using a UUID is that we will
have an application hosted at different sites in different
databases.  We will need to aggregate the data back into a single
database from time to time and we want to avoid PK collisions.
   Is there a significant performance difference between using int
primary keys and string primary keys in Postgres?
   Thanks,
    -M@

В списке pgsql-general по дате отправления:

Предыдущее
От: Thorsten Kraus
Дата:
Сообщение: Re: Stored procedure
Следующее
От: "Hakan Kocaman"
Дата:
Сообщение: Re: Stored procedure