Re: Mount Point /datastorage is 93 percent full

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: Mount Point /datastorage is 93 percent full
Дата
Msg-id EAC81316-1C04-43C8-A98D-7EC499E6D2D8@elevated-dev.com
обсуждение исходный текст
Ответ на Mount Point /datastorage is 93 percent full  (Satyamnaidu Gokeda <satyamnaidu215@gmail.com>)
Список pgsql-admin
Дерево обсуждения 
> 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 по дате отправления:

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: Mount Point /datastorage is 93 percent full
Следующее
От: manoj kathar
Дата:
Сообщение: Re: error : missing chunk number 3 for toast value 14146136 in pg_toast_8895383