Re: Sequences - jumped after power failure

From: nobs(at)nobswolf(dot)info (Emil Obermayr)
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Sequences - jumped after power failure
Date: 2008-04-15 10:50:49
Message-ID: 20080415105049.GF23737@nobswolf.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-novice by date

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