Joseph Shraibman <joseph@xtenit.com> writes:
> Tom Lane wrote:
>> 3 times, unless you changed the default cache setting.
> OK, next question: How many times does it write the new sequence value to the disk?
Less than that --- there's aggregation of WAL updates for sequences.
See the code in backend/commands/sequence.c.
regards, tom lane