Oscar Tuscon <obtuse@bmwe30.net> writes:
> I found the average select nextval() call was taking 2ms, which seems
> a bit slow to me. Throw in the fsync I suppose and that'd explain it.
> Interestingly, in the tests I ran the minimum select nextval() was
> 400us, and the max was 35ms, with an average of 2ms.
I believe that nextval() only actually writes to disk once every 32
calls. This probably explains the variability.
regards, tom lane