Hi, On 2014-02-15 12:22:56 +0100, Clemens Eisserer wrote: > > They will lost after a crash, but after a regular shutdown / restart all > > data in the table. > > Yes, the semantics are clearly stated in the documentation. > What I wonder is whether postgresql will issue flush/fsync operations > when unlogged tables are modified? No fsyncs will be issued in the common paths, and they won't be written to disk by !shutdown checkpoints. But they *will* be written to disk if there's not enough space in shared_buffers for all the data. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
