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.
Regards,
Atul
On 6/7/21, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> 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 directory size is getting
>> increased'?
>>
>> my postgres version is 9.6.
>
> Based on the little information you gave us, it could be one of
>
> - temporary files that get created by the query
> - you export the data into the data directory
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>