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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Peter <pmc(at)citylink(dot)dinoex(dot)sub(dot)org>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: SELECT creates millions of temp files in a single directory
Date: 2022-04-23 21:11:00
Message-ID: 409fbd2f-a4de-c4f0-0b2c-0f083868c9a8@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2022-04-23 21:13:41 Re: SELECT creates millions of temp files in a single directory
Previous Message David G. Johnston 2022-04-23 21:03:57 Re: SELECT creates millions of temp files in a single directory