Greg Smith <greg@xxxxxxxxxxxxxxx> writes: > If you're OK with the possibility of losing a measurement in the case of a > system crash Then I'd say use synchronous_commit = off for the transactions doing that, trading durability (the 'D' of ACID) against write performances. That requires 8.3 at least, and will not fsync() before telling the client the commit is done. Regards, -- dim -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general