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

Enno Wein <ennowein(at)yahoo(dot)com> writes:
> Every session (72 for now) creates and drops several (temp-) tables and
> indexes. Every session runs for about 30min, then does a final insert
> and exits afterwards.
> Depending on parallelism chosen, we run 8, 16 or 24 sessions in parallel.
> The main, (global-) table which persists has been declared as either
> logged or unlogged, there is much WAL traffic in any case.

That still sounds like it'd just add up to a few temp table creations/
deletions per minute, which would not account for any huge volume of
WAL traffic. I'm suspicious that somewhere you've got activity going
into a table that you forgot to make temp or unlogged.

You might grab pg_xlogdump or a logical decoding tool and look into
the WAL stream to see exactly what's going by.

regards, tom lane