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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

  From Date Subject
Next Message Steve T 2008-04-15 17:04:00 Re: Sequences - jumped after power failure
Previous Message Tom Lane 2008-04-15 14:58:17 Re: Sequences - jumped after power failure