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