Re: [GENERAL] number of tables limited over time (not simultaneous)?

2007-02-21 Thread Richard Huxton
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

[GENERAL] number of tables limited over time (not simultaneous)?

2007-02-20 Thread dave crane
We've settled upon a method for gathering raw statistics from widely scattered data centers of creating one sequence per-event, per minute. Each process (some lapp, some shell, some python, some perl etc) can call a shell script which calls ssh->psql to execute a nextval('event') sequence. P