On Sat, Aug 23, 2008 at 7:31 PM, Loic Petit <[EMAIL PROTECTED]> wrote: > One sensor (so one table) sends a packet each seconds (for 3000 sensors). > => So we have : 1 insert per second for 3000 tables (and their indexes). > Hopefully there is no update nor delete in it...
Wait, I'm confused, I thought you said earlier that for the big test the tables only had a few rows. I'd expect it to be quite a bit bigger if you're inserting into a table once a second for any period. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
