Re: Sequence moves forward when failover is triggerred

From: Berend Tober <btober(at)broadstripe(dot)net>
To: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
Cc: Andy Chambers <achambers(at)mcna(dot)net>, pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Sequence moves forward when failover is triggerred
Date: 2012-07-11 05:01:59
Message-ID: 4FFD08C7.1020909@computer.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Craig Ringer wrote:
> On 07/11/2012 07:23 AM, Andy Chambers wrote:
>>
>> I think I made a poor decision by having our application
>> generate checkbook numbers on demand using sequences.
>
> Sure did. Sequences are exempt from most transactional rules;
> that's why they're fast and lock-free.
>

This may be another case for the "gap-less" sequence (I hate that
term ... please let's call it a "uniformly-increasing sequence").

http://archives.postgresql.org/pgsql-general/2006-08/msg00744.php

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Toby Corkindale 2012-07-11 07:43:37 Bug? Prepared queries continue to use search_path from their preparation time
Previous Message Craig Ringer 2012-07-11 03:47:46 Re: Sequence moves forward when failover is triggerred