[EMAIL PROTECTED] 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to