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

Clemens Eisserer <linuxhippy(at)gmail(dot)com> wrote:

> 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

They will lost after a crash, but after a regular shutdown / restart all
data in the table.

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°