Will modifications to unlogged tables also be flused to disk?

From: Clemens Eisserer <linuxhippy(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Will modifications to unlogged tables also be flused to disk?
Date: 2014-02-15 11:03:11
Message-ID: CAFvQSYSJkGoRLpnn878B=uokeRSfjr1KfBatNzPYisC2J-x+Mw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2014-02-15 11:12:48 Re: Will modifications to unlogged tables also be flused to disk?
Previous Message James Harper 2014-02-15 09:50:08 Re: type aliases