Re: pg_ctl stop -m immediate on the primary server inflates sequences - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: pg_ctl stop -m immediate on the primary server inflates sequences
Date
Msg-id 16F3BE7D2A60E9334F1CD93C@amenophis
Whole thread Raw
Responses Re: pg_ctl stop -m immediate on the primary server inflates sequences  (Boszormenyi Zoltan <zb@cybertec.at>)
List pgsql-hackers

--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


pgsql-hackers by date:

Previous
From: Boszormenyi Zoltan
Date:
Subject: Re: pg_ctl stop -m immediate on the primary server inflates sequences
Next
From: Joachim Wieland
Date:
Subject: Re: a faster compression algorithm for pg_dump