| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Peter <pmc(at)citylink(dot)dinoex(dot)sub(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-generallists(dot)postgresql(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 22:55:59 |
| Message-ID: | 8019ae53-c90e-7ddc-3827-5d923a4bd8e2@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2022-04-24 01:36:29 | Re: SELECT creates millions of temp files in a single directory |
| Previous Message | Peter | 2022-04-23 22:40:20 | Re: SELECT creates millions of temp files in a single directory |