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

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: Will modifications to unlogged tables also be flused to disk?
Дата
Msg-id CAKoxK+7HTtMipHCPSyxHa32_M8z9wFTn1GmeufgcXY7iwV7DmQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 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?  (Clemens Eisserer <linuxhippy@gmail.com>)
Список pgsql-general
On Sat, Feb 15, 2014 at 12:38 PM, Clemens Eisserer <linuxhippy@gmail.com> wrote:
> Ok thats really bad news :/
> After reading the discussion about calling unlogged tables "in memory"
> or "cached" I actually had high hopes pgql would take advantage of the
> fact that data of unlogged tables are not preserved at recovery.

Sorry, I could be misunderstanding here, but if the final aim is to
reduce the writes, why not tweaking wal settings and checkpoints? I
mean, is it possible to find a good solution or you need a kind of in
memory storage?

Luca


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Will modifications to unlogged tables also be flused to disk?
Следующее
От: Clemens Eisserer
Дата:
Сообщение: Re: Will modifications to unlogged tables also be flused to disk?