Re: Sequences - jumped after power failure

Поиск
Список
Период
Сортировка
От nobs@nobswolf.info (Emil Obermayr)
Тема Re: Sequences - jumped after power failure
Дата
Msg-id 20080415105049.GF23737@nobswolf.info
обсуждение исходный текст
Ответ на Re: Sequences - jumped after power failure  (Steve T <steve@retsol.co.uk>)
Ответы Re: Sequences - jumped after power failure  (Steve T <steve@retsol.co.uk>)
Список pgsql-novice
Maybe its because the sequence gets a batch of IDs in the cache and
discards it with a crash? So unused sequence-ID get lost, while the
sequence is reset to the number of the last really used ID during a
normal shutdown?

Just a thought.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Steve T
Дата:
Сообщение: Re: Sequences - jumped after power failure
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Sequences - jumped after power failure