Re: sequence increment jumps?

From: Benjamin Smith <lists(at)benjamindsmith(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: sequence increment jumps?
Date: 2007-01-25 18:44:27
Message-ID: 200701251044.27639.lists@benjamindsmith.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-01-25 18:44:33 Re: Stats collector frozen?
Previous Message Magnus Hagander 2007-01-25 18:35:56 Re: Stats collector frozen?