2009/5/28 Nikolas Everett <nik9000@xxxxxxxxx>: > Option 1 is about somewhere between 2 and 3 times more work for the database > than option 2. Yes, for writes. > Do you need every sensor update to hit the database? In a situation like We can't miss an update - they can be delayed but they all need to be recorded. > this I'd be tempted to keep the current values in the application itself and > then sweep them all into the database periodically. If some of the sensor > updates should hit the database faster, you could push those in as you get > them rather than wait for your sweeper. This setup has the advantage that > you can scale up the number of sensors and the frequency the sensors report > without having to scale up the disks. You can also do the sweeping all in > one transaction or even in one batch update. It would be nice, but then we need to invest more effort in making the front-end buffering resilient. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
