Quick Links

Serial Jumping

From:	db(dot)subscriptions(at)shepherdhill(dot)biz
To:	pgsql-general(at)postgresql(dot)org
Subject:	Serial Jumping
Date:	2009-01-27 04:55:48
Message-ID:	20090127055548.bpcc4i3hcgs00sco@webmail.shepherdhill.biz
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: Serial Jumping at 2009-01-27 05:14:48 from Bill Moran
Re: Serial Jumping at 2009-01-27 06:10:18 from A. Kretschmer
Re: Serial Jumping at 2009-01-27 16:29:01 from Devrim GÜNDÜZ
Re: Serial Jumping at 2009-02-01 10:21:22 from Jasen Betts

Browse pgsql-general by date

	From	Date	Subject
Next Message	Bill Moran	2009-01-27 05:14:48	Re: Serial Jumping
Previous Message	Tom Lane	2009-01-27 04:18:32	Re: What is the best plan to upgrade PostgreSQL from an ancient version?