Skip site navigation (1) Skip section navigation (2)

Re: Sequences - jumped after power failure

From: Steve T <steve(at)retsol(dot)co(dot)uk>
To: Emil Obermayr <nobs(at)nobswolf(dot)info>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Sequences - jumped after power failure
Date: 2008-04-15 15:51:51
Message-ID: 1208274711.27471.293.camel@retsol610 (view raw or flat)
Thread:
Lists: 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.


In response to

pgsql-novice by date

Next:From: Steve TDate: 2008-04-15 17:04:00
Subject: Re: Sequences - jumped after power failure
Previous:From: Tom LaneDate: 2008-04-15 14:58:17
Subject: Re: Sequences - jumped after power failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group