| From: | Jayson Hreczuck <jayson(dot)hreczuck(at)studentuniverse(dot)com> |
|---|---|
| To: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Temporary Files |
| Date: | 2021-09-14 14:22:08 |
| Message-ID: | CAHg7=h6UAxB5ysxPLMWijZXx1tn0BE3VvLGUSDaxwE9yRSaaQw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I'll second pg_badger. Very useful tool for this.
On Tue, Sep 14, 2021 at 10:20 AM Campbell, Lance <lance(at)illinois(dot)edu> wrote:
> Thanks Tom for responding. I think this will help me out.
>
> Lance
>
> On 9/14/21, 8:58 AM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Campbell, Lance" <lance(at)illinois(dot)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 AdministratorC: +1 617.571.9861*130
Turner St, Ste 530, Waltham, MA 02453
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bossart, Nathan | 2021-09-14 18:00:44 | Re: Estimating HugePages Requirements? |
| Previous Message | Campbell, Lance | 2021-09-14 14:20:22 | Re: Temporary Files |