Re: SELECT creates millions of temp files in a single directory

On 4/23/22 12:50, Peter wrote:


>     People seem to have been brainwashed by Web-Services and OLTP,
>     and now think the working set must always fit in memory. But this
>     is only one possible usecase, it is not the exclusive only one.

This is no-win situation as most of the complaints in recent years have 
been that Postgres was/is to conservative in its default settings and is 
not taking advantage of newer more powerful hardware.

-- 
Adrian Klaver
adrian.klaver@aklaver.com