Re: sequence skips 30 values, how? - Mailing list pgsql-general

From Angva
Subject Re: sequence skips 30 values, how?
Date
Msg-id 1170261272.680497.145650@p10g2000cwp.googlegroups.com
Whole thread Raw
In response to sequence skips 30 values, how?  (Geoffrey <esoteric@3times25.net>)
Responses Re: sequence skips 30 values, how?
List pgsql-general
As others have said, sequences can have gaps. In fact, the thought of
a gap-free sequence is scary to me. Unless you do very few inserts,
"gap-free sequence" is pretty much synonymous with "not scalable". If
your goal is to generate a unique number for each row (which is
usually the case), then gaps should be fine.

Though I must admit I have occasionally wished for sequences with a
GAPFREE option...For small, static look-up tables that I update once
in a blue moon. It's just easier on the eyes to have 1,2,3,4,5 than 1,
25, 2405, 95720, 59028598253.

Mark

On Jan 31, 7:43 am, esote...@3times25.net (Geoffrey) wrote:
> We are trying to track down an issue with our PostgreSQL application.
> We are running PostgreSQL 7.4.13 on Red Hat Enterprise ES 3.
>
> We have a situation where the postgres backend process drops core and
> dies.  We've tracked this to an unusual situation where a sequence value
> that is being created during the process that is causing the core file
> generation.  The thing that is bizarre is that the sequence value skips
> 30+ entries.
>
> How is this even possible?  Any suggestions would be greatly appreciated.
>
> --
> Until later, Geoffrey




pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: How to allow users to log on only from my application not from pgadmin
Next
From: Alexandre Leclerc
Date:
Subject: Ordering problem with varchar (DESC)