Re: Will modifications to unlogged tables also be flused to disk?

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