Will modifications to unlogged tables also be flused to disk? - Mailing list pgsql-general

From Clemens Eisserer
Subject Will modifications to unlogged tables also be flused to disk?
Date
Msg-id CAFvQSYSJkGoRLpnn878B=uokeRSfjr1KfBatNzPYisC2J-x+Mw@mail.gmail.com
Whole thread Raw
Responses Re: Will modifications to unlogged tables also be flused to disk?  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: Will modifications to unlogged tables also be flused to disk?  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Hi,

I would like to use postgresql's unlogged tables on an embedded system
to avoid frequent writes to flash memory.
While documentation clearly states that unlogged tables don't have to
go through the WAL, it doesn't mention what happens to the data when
it is written directly to the database.

Will unlogged tables also cause sync/fsync calls, or will they stay in
the page cache of the system as they will be lost anyway after a
recovery?

Thank you in advance, Clemens


pgsql-general by date:

Previous
From: James Harper
Date:
Subject: Re: type aliases
Next
From: Andreas Kretschmer
Date:
Subject: Re: Will modifications to unlogged tables also be flused to disk?