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 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
signature.asc
Description: This is a digitally signed message part
