Postgres Pro
Downloads
Home   >   mailing lists

Serial Jumping - Mailing list pgsql-general

From db.subscriptions@shepherdhill.biz
Subject Serial Jumping
Date
Msg-id 20090127055548.bpcc4i3hcgs00sco@webmail.shepherdhill.biz
Whole thread Raw
Responses Re: Serial Jumping  (Bill Moran <wmoran@potentialtech.com>)
Re: Serial Jumping  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Serial Jumping  (Devrim GÜNDÜZ <devrim@gunduz.org>)
List pgsql-general
Tree view 
Hi,

I have a table with BIG SERIAL field as Primary KEY. During high load,
entries in the BIG SERIAL field are jumped. One could see a row with
1367 and expecting the next INSERT to be 1368, one would end up
getting 1369.

Please is this normal?

Regards,
Chris

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: What is the best plan to upgrade PostgreSQL from an ancient version?
Next
From: Bill Moran
Date:
Subject: Re: Serial Jumping