Re: sequence increment jumps? - Mailing list pgsql-general

From Benjamin Smith
Subject Re: sequence increment jumps?
Date
Msg-id 200701251044.27639.lists@benjamindsmith.com
Whole thread Raw
In response to Re: sequence increment jumps?  (Douglas McNaught <doug@mcnaught.org>)
Responses Re: sequence increment jumps?
List pgsql-general
On Thursday 25 January 2007 09:53, Douglas McNaught wrote:
> Nature of the beast.  Sequence increments aren't rolled back on
> transaction abort (for performance and concurrency reasons), so you
> should expect gaps.

Behavior long ago noted and accounted for. But I've always wondered why this
was so? Is there a specific reason for this behavior?

-Ben

--
"The best way to predict the future is to invent it."
- XEROX PARC slogan, circa 1978

pgsql-general by date:

Previous
From: "Ted Byers"
Date:
Subject: Re: Problem with result ordering
Next
From: Benjamin Smith
Date:
Subject: Re: Converting 7.x to 8.x