Re: base directory size getting increased

Hi Sir,

I don’t think there is any old connection connected as there is no process
I found from pg_stat_activity.

Is there any other way to trace out such sessions.

Regards
Atul

On Monday, June 7, 2021, Ravi Krishna <ravikrishna3(at)icloud(dot)com> 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.
> >
>
> Ideally applications which creates temp table should drop it when no
> longer needed.
> When not dropped, they get dropped automatically when the session which
> created
> them terminates. Looks like in your case both are not happening.
>
> Which is the oldest session still shown as connected?