--On 10. April 2010 09:26:41 +0200 Boszormenyi Zoltan <zb(at)cybertec(dot)at>
> The above is quite reproducable, "pg_ctl stop -m immediate"
> "usually" inflated my serial sequence, but I had two occasions
> when not. The 69 -> 70 was one. The inflated increase is always 33:
AFAIKS sequences are pre-logged with 32 values to WAL to avoid overhead. I
suspect this is why you are seeing those gaps.
pgsql-hackers by date
|Next:||From: Joachim Wieland||Date: 2010-04-10 12:18:09|
|Subject: Re: a faster compression algorithm for pg_dump|
|Previous:||From: Boszormenyi Zoltan||Date: 2010-04-10 07:31:04|
|Subject: Re: pg_ctl stop -m immediate on the primary server inflates