pgsql(at)mohawksoft(dot)com writes:
> Anyway, I'm not quite getting the idea of caching sequence values. I
> understand the performance benefits, but it seems problematic across
> multiple backends, almost ensuring "holes" in the sequence of numbers.
The point is to reduce lock contention on the sequence table. Since
lack-of-holes is explicitly *not* a design goal, there is no downside
that I see.
regards, tom lane