Re: BUG #15115: temporary AND unlogged tables for parallel db import
От | Enno Wein |
---|---|
Тема | Re: BUG #15115: temporary AND unlogged tables for parallel db import |
Дата | |
Msg-id | 33a6e05e-5dee-856e-d2a3-427eb190cc1e@yahoo.com обсуждение исходный текст |
Ответ на | Re: BUG #15115: temporary AND unlogged tables for parallel db import (Andrew Gierth <andrew@tao11.riddles.org.uk>) |
Ответы |
Re: BUG #15115: temporary AND unlogged tables for parallel db import
Re: BUG #15115: temporary AND unlogged tables for parallel db import |
Список | pgsql-bugs |
I think you made that clear :-) 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. On 3/16/18 07:31, Andrew Gierth wrote: >>>>>> "Enno" == Enno Wein <ennowein@yahoo.com> writes: > > Enno> This is an enhancement request to enable having tables which are > Enno> both temporary and unlogged. > > ALL TEMPORARY TABLES ARE ALREADY UNLOGGED. > ========================================== > > I don't know how to make this any clearer. >
В списке pgsql-bugs по дате отправления: