Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT creates millions of temp files in a single directory - Mailing list pgsql-general

From Adrian Klaver
Subject Re: SELECT creates millions of temp files in a single directory
Date
Msg-id 409fbd2f-a4de-c4f0-0b2c-0f083868c9a8@aklaver.com
Whole thread Raw
In response to SELECT creates millions of temp files in a single directory  (Peter <pmc@citylink.dinoex.sub.org>)
Responses Re: SELECT creates millions of temp files in a single directory
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: SELECT creates millions of temp files in a single directory
Next
From: Tom Lane
Date:
Subject: Re: SELECT creates millions of temp files in a single directory