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.
>