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