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?
