From: Tom Lane <tgl@sss.pgh.pa.us>
To: Manoj Kumar <manojkumar@ameyo.com>
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16739: Temporary files not deleting from data folder on disk
In-reply-to: 
 <CAO-7TQPk5nHpB+n5Lmv2xPRXhPLgpr47tvO0Lr_Ghk8A_dkitg@mail.gmail.com>
References: <16739-01bbd1b6e3a30313@postgresql.org>
 <57259.1606145601@sss.pgh.pa.us>
 <CAO-7TQPk5nHpB+n5Lmv2xPRXhPLgpr47tvO0Lr_Ghk8A_dkitg@mail.gmail.com>
Comments: In-reply-to Manoj Kumar <manojkumar@ameyo.com>
	message dated "Tue, 24 Nov 2020 21:17:38 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <288676.1606236136.1@sss.pgh.pa.us>
Date: Tue, 24 Nov 2020 11:42:16 -0500
Message-ID: <288677.1606236136@sss.pgh.pa.us>
Precedence: bulk

Manoj Kumar <manojkumar@ameyo.com> writes:
> Adding more data to support my point in form of attachment.

Well, those t-something files are certainly temporary tables,
so what you've got there is that some session has created a bunch
of quite large temporary tables (the "t20_" files) and another has
created a bunch of rather smaller ones (the "t62_" group).

However, this is not direct evidence of PG misbehavior.  You've
offered no reason to think that the sessions that made those files
have exited.  Even if you're sure they have, we can't do anything
to help you on the basis of the zero facts you've supplied so far
about what the sessions were doing.

If you can provide a reproducible test case that leaks temp tables,
we could get to the bottom of it pretty quickly, I'm sure.  But
we cannot help you on the basis of what you've shown us.

			regards, tom lane