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=1xc2NAJD192QfkQj3sn+gtzXtp-7UoziKimNp0tWBNKoQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Will modifications to unlogged tables also be flused to disk?  (frank <halldu0815@gmail.com>)
Список pgsql-general

On Mon, Dec 8, 2014 at 4:43 AM, frank <halldu0815@gmail.com> wrote:
Jeff Janes wrote
> 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

Hi,

just to understand this answer:

Is it *NOT* possible to create an unlogged table where inserts or updates
will *NOT* modify the WAL files?


Correct.  
 

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

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: Removing duplicate records from a bulk upload
Следующее
От: Edson Richter
Дата:
Сообщение: Divergences in view source code - both servers 9.3.5