Hi,
Is there any way to check which temporary file is being used by which query.
Any query/ view to check it, could you share or suggest ?
Is there any way to be safe while deleting such files.
Regards
Atul
On Monday, June 7, 2021, Laurenz Albe <
laurenz.albe@cybertec.at> wrote:
On Mon, 2021-06-07 at 17:48 +0530, Atul Kumar wrote:
> initially pgsql_tmp size was 87 GB and after execution of query it was
> started increasinng beyond 87GBs so yes, pgsql_tmp directory size is
> getting increased while exporting data into csv file.
>
> But once I rolled back the query, pgsql_tmp directory it was back to
> 87 GBs so please help me in telling how do I clean that 87GB of space
> of pgsql_tmp directory.
The files in that directory will always be cleaned up when the
query that uses the temporary files is done.
The backend process ID of the query is part of the temporary file name.
It could be that such files are left behind after a crash.
If you are sure that the don't belong to a running query (for example,
if their modification timestamp is old), you can delete them.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com