Re: [GENERAL] GENERAL : [Can somebody explain about Base directory] - Mailing list pgsql-general

From Scott Mead
Subject Re: [GENERAL] GENERAL : [Can somebody explain about Base directory]
Date
Msg-id CAKq0gvJ6h6CxVB3HTys+YTxkgvx-Ex0ej6-ChPPkqsEc_RmDgg@mail.gmail.com
Whole thread Raw
In response to [GENERAL] GENERAL : [Can somebody explain about Base directory]  (VENKTESH GUTTEDAR <venkteshguttedar@gmail.com>)
List pgsql-general


On Mon, May 1, 2017 at 11:41 AM, VENKTESH GUTTEDAR <venkteshguttedar@gmail.com> wrote:
Hello All,

    Base directory is consuming to much memory, leading to no space on server and stopping the application

    Somebody please explain why it takes so much memory and is it safe to delete those files.?


The base directory is where your actual data (tables, indexes) are stored.  It is NOT safe to delete from that directory manually.  It would be better to login to the database and see if you can either drop tables or indexes.  If you do a 'DROP TABLE <tablename>;' in the database, it will delete from the base directory.  DO NOT DELETE FROM THE BASE DIRECTORY manually unless you know what you are doing.

   It is possible that you have bloat causing you space issues, but, that's a harder thing to solve (https://www.openscg.com/2016/11/postgresql-bloat-estimates/)
 
--
Regards :
Venktesh Guttedar.




--
--
Scott Mead
Sr. Architect
OpenSCG

pgsql-general by date:

Previous
From: VENKTESH GUTTEDAR
Date:
Subject: [GENERAL] GENERAL : [Can somebody explain about Base directory]
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] GENERAL : [Can somebody explain about Base directory]