Re: GENERAL : [Can somebody explain about Base directory]

From: Scott Mead <scottm(at)openscg(dot)com>
To: VENKTESH GUTTEDAR <venkteshguttedar(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: GENERAL : [Can somebody explain about Base directory]
Date: 2017-05-01 15:47:46
Message-ID: CAKq0gvJ6h6CxVB3HTys+YTxkgvx-Ex0ej6-ChPPkqsEc_RmDgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, May 1, 2017 at 11:41 AM, VENKTESH GUTTEDAR <
venkteshguttedar(at)gmail(dot)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 <http://openscg.com>*
http://openscg.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-05-01 15:50:15 Re: GENERAL : [Can somebody explain about Base directory]
Previous Message VENKTESH GUTTEDAR 2017-05-01 15:41:18 GENERAL : [Can somebody explain about Base directory]