Re: sequences and "addval('myseq', value)"

pgsql@mohawksoft.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