Re: sequence caches - Mailing list pgsql-general

From Tom Lane
Subject Re: sequence caches
Date
Msg-id 4283.1053486670@sss.pgh.pa.us
Whole thread Raw
In response to sequence caches  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: How to deny user changing his own password?
Next
From: Tom Lane
Date:
Subject: Re: new mail server for PGSQL-GENERAL ?