From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Manoj Kumar <manojkumar(at)ameyo(dot)com> |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #16739: Temporary files not deleting from data folder on disk |
Date: | 2020-11-24 16:42:16 |
Message-ID: | 288677.1606236136@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Manoj Kumar <manojkumar(at)ameyo(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2020-11-24 17:02:40 | BUG #16744: ts_headline behaves incorrectly with <-> and proximity operators |
Previous Message | Tom Lane | 2020-11-24 16:25:51 | Re: BUG #16743: psql doesn't show whole expression in stored column |