[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