Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oJAPB-0000De-FS for pgsql-admin@arkaria.postgresql.org; Wed, 03 Aug 2022 09:11:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oJAPA-0003FV-CX for pgsql-admin@arkaria.postgresql.org; Wed, 03 Aug 2022 09:11:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oJAPA-0003FL-2K for pgsql-admin@lists.postgresql.org; Wed, 03 Aug 2022 09:11:04 +0000 Received: from mail-pj1-x1031.google.com ([2607:f8b0:4864:20::1031]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oJAP8-00035u-Ja for pgsql-admin@lists.postgresql.org; Wed, 03 Aug 2022 09:11:03 +0000 Received: by mail-pj1-x1031.google.com with SMTP id s5-20020a17090a13c500b001f4da9ffe5fso1335759pjf.5 for ; Wed, 03 Aug 2022 02:11:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=Fnxr9S2d8Ne4PUzXfIptAg6VWAvvlGYpbwBfFPFYmUE=; b=isZqaAb1XvuyY2k8RGmgjdUgNax0X6GeqHhHzrxzW5Tm5ZsCLwl4UcJsCVFLCRtZm6 S7P8Qhmp93lM6dQaIlMqDOeVOn1J2U8dx/DBfDN/VFp9F7XGS+fhikptjcShDxuMF2Hz DNWVEhveFa5N/2s1PwoW7mxOPCe37tWCOKVTgT+uYAEIeKMTN08KJBoB4JC5ybE1/+1P KYjyxSd0mLwOTDFWPYgP5jzamIi5vD3YmPV+9SoIng813zu982204uhseFxww6Wq4enQ QQSkvoYkUnABWgMEHyzK5H+X4Tp2ruQoidaIKobytPZI4/8BZ5176AxcObY8QMPF8oia w6ig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=Fnxr9S2d8Ne4PUzXfIptAg6VWAvvlGYpbwBfFPFYmUE=; b=w98BG3NzqkCqlDwNwCZl3NJtL8Fsz6vXxTb2cJA2Tl63fpQigioDuCXLbEjf7gUh6I iu19zoXAUZ+GvWlZwDFzqGaAR6FW3WFHZ7t8BiCTNQBm75QeRb91nn/sf0EZIBRpKAyx AV/BPL1BFK9qBCzX9b7GBcPhz5KhCP++zGTb1gVZ+sNK2rwW3E0hxX1rZhsO15MQBhT6 HP0fxssZY8WIODHZoD2+pB4x/z/cCdBvWb9xUPk9/SX7ld6tuxji1G2EdPjwD7xtZx9Y qiwpQWFR4cZBhQffKrs2tyC93tX/d1H3yUepEapEZ2bccDI8JmRUOhBHdtjhoPER640/ i/Lw== X-Gm-Message-State: ACgBeo1B3SBC0bNftdHevtC86VMgmmhG+dp9K/szXkbQfzJab5nL5Os2 gLrqnGnY24tv7B/JVqhZik4= X-Google-Smtp-Source: AA6agR5lkKP5qUaVzslAzNlgkj1LTAn1x3RMiFtk9AqCZiAdkzLDT/tVDyqMxdyxndajR1zTmPf1yw== X-Received: by 2002:a17:903:492:b0:16d:d562:42d6 with SMTP id jj18-20020a170903049200b0016dd56242d6mr23171360plb.47.1659517860826; Wed, 03 Aug 2022 02:11:00 -0700 (PDT) Received: from jrouhaud (2001-b011-1006-b775-0d9d-453c-87f6-1cc5.dynamic-ip6.hinet.net. [2001:b011:1006:b775:d9d:453c:87f6:1cc5]) by smtp.gmail.com with ESMTPSA id q12-20020a17090a7a8c00b001f506804af3sm1017930pjf.52.2022.08.03.02.10.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 03 Aug 2022 02:11:00 -0700 (PDT) Date: Wed, 3 Aug 2022 17:10:57 +0800 From: Julien Rouhaud To: Satyamnaidu Gokeda Cc: pgsql-admin@lists.postgresql.org Subject: Re: Mount Point /datastorage is 93 percent full Message-ID: <20220803091057.vxzprd63y3m6ktx2@jrouhaud> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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.