Postgres Pro
Downloads
Home   >   mailing lists

Distributed systems and primary keys - Mailing list pgsql-general

From Melvin Call
Subject Distributed systems and primary keys
Date
Msg-id CADGQN57=W5TV6bJLC4ngY+-E+_V-_=60zP2Tzgz87kYY1MqzOw@mail.gmail.com
Whole thread Raw
Responses Re: Distributed systems and primary keys
List pgsql-general
Tree view
Hello list,

Can anyone point me to some reading material on how auto-generated sequence primary keys are handled on distributed systems? I think the advice used to be to use GUIDs, but I thought I read somewhere that PostgreSQL now assigns a pool of numbers to each node when a sequence is implemented. I have searched the PostgreSQL 9.1.5 Documentation, but apparently my search terms are not quite what it takes, or dreamt that up.

Thanks,
Melvin

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Changing the function used in an index.
Next
From: Kevin Grittner
Date:
Subject: Re: transactional swap of tables