Re: BUG #15115: temporary AND unlogged tables for parallel db import - Mailing list pgsql-bugs

From Stephen Frost
Subject Re: BUG #15115: temporary AND unlogged tables for parallel db import
Date
Msg-id 20180316145642.GI2416@tamriel.snowman.net
Whole thread Raw
In response to Re: BUG #15115: temporary AND unlogged tables for parallel db import  (Enno Wein <ennowein@yahoo.com>)
List 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

Attachment

pgsql-bugs by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: BUG #15115: temporary AND unlogged tables for parallel db import
Next
From: Tom Lane
Date:
Subject: Re: BUG #15115: temporary AND unlogged tables for parallel db import