Postgres Pro
Downloads
Home   >   mailing lists

Re: Mount Point /datastorage is 93 percent full - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Mount Point /datastorage is 93 percent full
Date
Msg-id EAC81316-1C04-43C8-A98D-7EC499E6D2D8@elevated-dev.com
Whole thread Raw
In response to Mount Point /datastorage is 93 percent full  (Satyamnaidu Gokeda <satyamnaidu215@gmail.com>)
List pgsql-admin
Tree view 
> On Aug 8, 2022, at 7:24 AM, Satyamnaidu Gokeda <satyamnaidu215@gmail.com> wrote:
>
> Postgres DB cluster mount point size /data 1.5TB used 200GB free 1.3TB when query running temp file size increased
to1.3TB   also query getting failed.  


You are correct that your limit is 50GB. I miscounted places in my prior post, sorry for the confusion.

However my point still stands: either this data is VERY large for that one root node, or you have a cycle in the data.
Areyou sure you do not have a cycle in the data?

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Mount Point /datastorage is 93 percent full
Next
From: manoj kathar
Date:
Subject: Re: error : missing chunk number 3 for toast value 14146136 in pg_toast_8895383