On Mon, 2021-06-07 at 21:58 +0530, Atul Kumar wrote:
> On Monday, June 7, 2021, Laurenz Albe wrote:
> > On Mon, 2021-06-07 at 17:48 +0530, Atul Kumar wrote:
> > > 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 87G
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 wrote:
> On Mon, 2021-06-07 at 17
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 wrote:
> >
> > initially pgsql_tmp size was 87 GB and after execution
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_
>
> 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
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 tellin
On Mon, 2021-06-07 at 16:11 +0530, Atul Kumar wrote:
> I have a query from which I am trying to export the data into a csv
> file(around 10 lakhs record) but when I am doing so the base sub
> directory size of data directory is getting increased.
>
> can someone help me in telling 'why base sub d
