dave crane wrote:
We've settled upon a method for gathering raw statistics from widely scattered data centers of creating one sequence per-event, per minute.
Aside from security concerns, did we miss something? Should I be worried we're going through ~60,000 sequences per day?
Well, you'll want to make sure you're vacuuming the system tables regularly. And you might want to make sure your code can retry creating the sequences once OIDs wrap around.
Not sure I'd have thought of doing things this way - I'd probably have totalled figures outside the database and then summarised them once a minute.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/