Re: BUG #15115: temporary AND unlogged tables for parallel db import

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: BUG #15115: temporary AND unlogged tables for parallel db import
Дата
Msg-id 20180316145642.GI2416@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: BUG #15115: temporary AND unlogged tables for parallel db import  (Enno Wein <ennowein@yahoo.com>)
Список pgsql-bugs
Greetings,

* Enno Wein (ennowein@yahoo.com) wrote:
> However, it doesn't seem to work like that. Even with ONLY either
> unlogged (the global ones) and temprorary tables (the local ones), the
> system still produces a huge amount of WAL/checkpoint writes. In fact,
> the "wal-writer" and "checkpoint" processes are the biggest writers in
> the system. checkpoint process uses up to 9GB of Ram and wal produces
> more writes than any other process.

"Doesn't seem to work like that" really isn't enough to go on.  If you'd
like for someone to look into this, posting a reproducible test case
which illustrates the bug you think you've found would be your best bet.

Thanks!

Stephen

Вложения

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

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: BUG #15115: temporary AND unlogged tables for parallel db import
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15115: temporary AND unlogged tables for parallel db import