| From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
|---|---|
| To: | db(dot)subscriptions(at)shepherdhill(dot)biz |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Serial Jumping |
| Date: | 2009-01-27 16:29:01 |
| Message-ID: | 1233073741.15799.9.camel@laptop.gunduz.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2009-01-27 at 05:55 +0100, db(dot)subscriptions(at)shepherdhill(dot)biz
wrote:
> 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?
Yes, but there is a way to get rid of that:
http://www.varlena.com/GeneralBits/130.php
Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2009-01-27 16:37:33 | Re: Text search with ispell |
| Previous Message | Markova, Nina | 2009-01-27 16:26:13 | FW: information about tables via psql |