Re: Sequences - jumped after power failure

Поиск
Список
Период
Сортировка
От Steve T
Тема Re: Sequences - jumped after power failure
Дата
Msg-id 1208274711.27471.293.camel@retsol610
обсуждение исходный текст
Ответ на Re: Sequences - jumped after power failure  (nobs@nobswolf.info (Emil Obermayr))
Список pgsql-novice
Emil,
That would tend to make sense given the results I am seeing. I am/was just paranoid that I've lost data - but everything says not an that its just a blip in the sequencing.

On Tue, 2008-04-15 at 12:50 +0200, Emil Obermayr wrote:
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 по дате отправления:

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