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

On 4/23/22 15:40, Peter wrote:
> On Sat, Apr 23, 2022 at 05:13:41PM -0400, Tom Lane wrote:

> And btw, I probably lost-in-translation the relevant info about the
> running version:
> 
> Name           : postgresql12-server
> Version        : 12.10
> Installed on   : Mon Apr  4 04:13:18 2022 CEST
> Origin         : databases/postgresql12-server
> Architecture   : FreeBSD:13:amd64
> 

> | Please see
> |
> | https://wiki.postgresql.org/wiki/Slow_Query_Questions
> |
> | for the sort of information we need to debug performance issues.
> 
> It is not a performance issue, it is a design question: You inflict
> pain on my beloved ZFS, and as a lover I react. ;)

Be that as it may, the requested information is still needed.



-- 
Adrian Klaver
adrian.klaver@aklaver.com