Will modifications to unlogged tables also be flused to disk?

Поиск
Список
Период
Сортировка
От Clemens Eisserer
Тема Will modifications to unlogged tables also be flused to disk?
Дата
Msg-id CAFvQSYSJkGoRLpnn878B=uokeRSfjr1KfBatNzPYisC2J-x+Mw@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: James Harper
Дата:
Сообщение: Re: type aliases
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Will modifications to unlogged tables also be flused to disk?