On 11/16/2010 04:46 PM, Josh Berkus wrote:
PostgreSQL 9.1 is likely to have, as a feature, the ability to create tables which are "unlogged", meaning that they are not added to the transaction log, and will be truncated (emptied) on database restart. Such tables are intended for highly volatile, but not very valuable, data, such as session statues, application logs, etc.
With the current patches, the data survives a restart just fine. I'd like to vote for: safe restart = save data bad crashy restart = drop date -Andy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general