From: Julien Rouhaud <rjuju123@gmail.com>
To: Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Mount Point /datastorage is 93 percent full
Date: Wed, 3 Aug 2022 17:10:57 +0800
Message-ID: <20220803091057.vxzprd63y3m6ktx2@jrouhaud> (raw)
In-Reply-To: <CAPXUohoHBoX9AmRkqxAVTwXrFJq7NMEzgb1Xb9e9q5G4sXCLSQ@mail.gmail.com>
References: <CAPXUohoHBoX9AmRkqxAVTwXrFJq7NMEzgb1Xb9e9q5G4sXCLSQ@mail.gmail.com>
Hi,
On Wed, Aug 03, 2022 at 02:32:05PM +0530, Satyamnaidu Gokeda wrote:
>
> We are getting following error while running this query. As checked
You probably forgot to copy the query here.
> org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error [53400]: ERROR:
> temporary file size exceeds temp_file_limit (52428800kB)
This error is raised because the query used more than temp_file_limit (see
https://www.postgresql.org/docs/current/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-DISK).
Your options are to raise that parameter (and maybe increase the
underlying disk given the message subject) or find a way to consume less disk
in temporary files. It's hard to know without knowing the query and the
underlying data, but maybe rewriting the query or splitting it into multiple
queries over a temporary table would work.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rjuju123@gmail.com, satyamnaidu215@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Mount Point /datastorage is 93 percent full
In-Reply-To: <20220803091057.vxzprd63y3m6ktx2@jrouhaud>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox