Re: Sequences - jumped after power failure - Mailing list pgsql-novice

From Steve T
Subject Re: Sequences - jumped after power failure
Date
Msg-id 1208274711.27471.293.camel@retsol610
Whole thread Raw
In response to Re: Sequences - jumped after power failure  (nobs@nobswolf.info (Emil Obermayr))
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sequences - jumped after power failure
Next
From: Steve T
Date:
Subject: Re: Sequences - jumped after power failure