Re: [GENERAL] Serial Jumping

2009-02-01 Thread Jasen Betts
On 2009-01-27, db.subscripti...@shepherdhill.biz wrote: > 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. > > Ple

Re: [GENERAL] Serial Jumping

2009-01-27 Thread Devrim GÜNDÜZ
On Tue, 2009-01-27 at 05:55 +0100, db.subscripti...@shepherdhill.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 13

Re: [GENERAL] Serial Jumping

2009-01-26 Thread A. Kretschmer
In response to db.subscripti...@shepherdhill.biz : > 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 i

Re: [GENERAL] Serial Jumping

2009-01-26 Thread Craig Ringer
Bill Moran wrote: > db.subscripti...@shepherdhill.biz wrote: >> 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

Re: [GENERAL] Serial Jumping

2009-01-26 Thread Bill Moran
db.subscripti...@shepherdhill.biz wrote: > > 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 n

[GENERAL] Serial Jumping

2009-01-26 Thread db . subscriptions
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 -- Sent via pgsql-general mailing