Re: sequence increment jumps?

Поиск
Список
Период
Сортировка
От Benjamin Smith
Тема Re: sequence increment jumps?
Дата
Msg-id 200701251044.27639.lists@benjamindsmith.com
обсуждение исходный текст
Ответ на Re: sequence increment jumps?  (Douglas McNaught <doug@mcnaught.org>)
Ответы Re: sequence increment jumps?  (Douglas McNaught <doug@mcnaught.org>)
Список 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 по дате отправления:

Предыдущее
От: "Ted Byers"
Дата:
Сообщение: Re: Problem with result ordering
Следующее
От: Benjamin Smith
Дата:
Сообщение: Re: Converting 7.x to 8.x