Search Postgresql Archives

Re: Sequence moves forward when failover is triggerred

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

 



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





--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[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