Joseph Shraibman <jks(at)selectacast(dot)net> writes:
> The way I understand it is a sequence cache works by getting more than one sequence id
> from the sequence at once, which saves shared memory locking. My question: If I make a
> query like:
> SELECT NEXTVAL('seqname'),NEXTVAL('seqname'),NEXTVAL('seqname');
> ... will that lock shared memory 3 times or just once?
3 times, unless you changed the default cache setting.
regards, tom lane