--On 10. April 2010 09:26:41 +0200 Boszormenyi Zoltan <zb@cybertec.at>
wrote:
> 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.
--
Thanks
Bernd