On Fri, Jul 12, 2013 at 10:04 AM, Koichi Suzuki wrote:
> In Postgres-XC, GTM assigns sequence value to all the transactions in its
> cluster. XC is a kind of tightly-coupled distributed system. In a
> loosely-coupled distributed system, where each database is autonomous, we
> may need another
On Fri, Jul 12, 2013 at 9:46 AM, Joshua D. Drake wrote:
>
> On 07/12/2013 07:23 AM, Melvin Call wrote:
>
>> 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 GUID
In Postgres-XC, GTM assigns sequence value to all the transactions in its
cluster. XC is a kind of tightly-coupled distributed system. In a
loosely-coupled distributed system, where each database is autonomous, we
may need another mechanism.
I've learned that logical replication (used to be bi
On 07/12/2013 07:23 AM, Melvin Call wrote:
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 nu
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 implemen
