Postgres Pro
Downloads
Home   >   mailing lists

Re: Temporary Files - Mailing list pgsql-admin

From Jayson Hreczuck
Subject Re: Temporary Files
Date
Msg-id CAHg7=h6UAxB5ysxPLMWijZXx1tn0BE3VvLGUSDaxwE9yRSaaQw@mail.gmail.com
Whole thread Raw
In response to Re: Temporary Files  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-admin
Tree view
I'll second pg_badger.  Very useful tool for this.

On Tue, Sep 14, 2021 at 10:20 AM Campbell, Lance <lance@illinois.edu> wrote:
Thanks Tom for responding.  I think this will help me out.

Lance

On 9/14/21, 8:58 AM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

    "Campbell, Lance" <lance@illinois.edu> writes:
    > Is there a way to see, track or log the queries that result in temporary file creation?

    The log_temp_files setting might be of use.

                        regards, tom lane



--


Jayson Hreczuck | Principal Database Administrator

C: +1 617.571.9861130 Turner St, Ste 530, Waltham, MA 02453

pgsql-admin by date:

Previous
From: "Campbell, Lance"
Date:
Subject: Re: Temporary Files
Next
From: Nikhil Shetty
Date:
Subject: initdb fails with error