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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Will modifications to unlogged tables also be flused to disk?
Дата
Msg-id CAMkU=1xr5bAX+geeQm9r3hki3VesW7vt_iPpRP_a+S04SuxXyg@mail.gmail.com
обсуждение исходный текст
Ответ на Will modifications to unlogged tables also be flused to disk?  (Clemens Eisserer <linuxhippy@gmail.com>)
Ответы Re: Will modifications to unlogged tables also be flused to disk?  (frank <halldu0815@gmail.com>)
Список pgsql-general
On Sat, Feb 15, 2014 at 3:03 AM, Clemens Eisserer <linuxhippy@gmail.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,

That's not really true.  There are no per-row WAL records.  There is still a per-transaction WAL record, the commit record. If you only care about the timing of the WAL and not the volume, changing to unlogged will not make a difference.  (These commit-only records are automatically dealt with asynchronously, even if synchronous-commit is on.)

Cheers,

Jeff


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Deleted files still open long after droping a database
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: CREATE EXTENSION does not seem to work in 9.2