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

Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> "Enno" == Enno Wein <ennowein@yahoo.com> writes:
>  Enno> However, it doesn't seem to work like that. Even with ONLY either
>  Enno> unlogged (the global ones) and temprorary tables (the local ones), the
>  Enno> system still produces a huge amount of WAL/checkpoint writes.

> So what you just said above is that you get a lot of WAL/checkpoint
> writes when using unlogged non-temporary tables. What this implies is
> that you have something _else_ going on, involving persistent tables
> (i.e. non-temporary non-unlogged tables - these are the only kind that
> get their data changes WAL-logged).

One theory is that the OP's workload involves a huge number of short-lived
temp tables, and then the WAL traffic is coming from the system catalog
changes involved in creating/dropping those tables (since even a temp
table must have entries in pg_class, pg_attribute, etc).  That's only
a theory though, given the lack of any hard evidence in this thread.

            regards, tom lane