Re: base directory size getting increased - Mailing list pgsql-general

From Laurenz Albe
Subject Re: base directory size getting increased
Date
Msg-id 1134292be1b2c9e33e6bd6dd0c0fd53a565403ce.camel@cybertec.at
Whole thread Raw
In response to base directory size getting increased  (Atul Kumar <akumar14871@gmail.com>)
Responses Re: base directory size getting increased  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Daniel Perrett
Date:
Subject: RE: Ideas for building a system that parses medical research publications/articles [EXT]
Next
From: Vijaykumar Jain
Date:
Subject: bottom / top posting