Postgres Pro
Downloads
Home   >   mailing lists

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

From nobs@nobswolf.info (Emil Obermayr)
Subject Re: Sequences - jumped after power failure
Date
Msg-id 20080415105049.GF23737@nobswolf.info
Whole thread Raw
In response to Re: Sequences - jumped after power failure  (Steve T <steve@retsol.co.uk>)
Responses Re: Sequences - jumped after power failure  (Steve T <steve@retsol.co.uk>)
List pgsql-novice
Tree view 
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: Steve T
Date:
Subject: Re: Sequences - jumped after power failure
Next
From: Tom Lane
Date:
Subject: Re: Sequences - jumped after power failure