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 1pctDc-0003d5-M3 for pgsql-general@arkaria.postgresql.org; Thu, 16 Mar 2023 19:24:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pctDb-0007MR-0q for pgsql-general@arkaria.postgresql.org; Thu, 16 Mar 2023 19:24:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pctDa-0007M1-GT for pgsql-general@lists.postgresql.org; Thu, 16 Mar 2023 19:24:54 +0000 Received: from mail-ed1-x536.google.com ([2a00:1450:4864:20::536]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pctDY-0004ut-4I for pgsql-general@lists.postgresql.org; Thu, 16 Mar 2023 19:24:53 +0000 Received: by mail-ed1-x536.google.com with SMTP id eh3so11753041edb.11 for ; Thu, 16 Mar 2023 12:24:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; t=1678994690; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=lvBFdNOG9LCmtw7D4npSOBmOgOAq6LyjHQbK+JyLFbM=; b=g9suF5a45MxnhOMQZIdrx3MQXH2q03+ppe4SijQkNAy2VSNmomVDLpCxX1u01BHdPh IXksJkAoAseS4FxV0dKrnMwDCeLjX173od2aotDNQpsVpWOOAR8WSrtKD3yhH8oRbBiu IV4b4nMvyVAkdre23qHTWBCG5NQor8VEMBbQ9Z8jVYruUFTZ4YoS9Vueo4IVfUgE5P4h tI6+CNjZbtv9cDkuSrAvj4Bq//pvg14ykJhmWs1Oj8zsNV1ZKggFU2z+vrMiZTHXbetG otD8SgFG6JhDeqAUR6lH/uYFBGVU7NRaM/E1UsICoE0bWAc784MzER4vYkGt5D3G3srB idCA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678994690; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=lvBFdNOG9LCmtw7D4npSOBmOgOAq6LyjHQbK+JyLFbM=; b=ohWi0qp4DPSsw2AiJ6KnNfhlzWoRq2qnpaN8WgyAGNPNj0StGYXFu60SFEgOe/O5yK 1cUSQHqiWHol0QsDbmFANkrzU/9UQiTAPvVKfy8xGAUnesRyYzCKOM6Ba/ORPCWyN97R pHzCe2ohIHaxTI+hxvHgL9Wt9l+oAEEnFDG7bcsttf572ZzFULsQ0AFDeB7tDYI954Gh lBfvGMd8sHs70ilveBzBWd/4frevISDOAQ4o9n7qgclW7a9yBRDzGYeML1LKFMAHKss1 plKhoC8aUTzNQuu0r1w8H7nSrwyNJcE9xZfgGcUij4iwNjPgUP2pMMVxU+ih/cu1ZhSG Iv0A== X-Gm-Message-State: AO0yUKXzpC4jjQXHPrDg55QagChg0xtDVBhyfGewLY/O8OcvUj6tudQc HDV1B8BneqYJZrX08f8b1fUrqA== X-Google-Smtp-Source: AK7set8G/D+vONMAtctf8ZVXT47mdUdFfvyKuThFReoeRw7NexbET9JUsJyxoYfoP2nnUWiY6C3vww== X-Received: by 2002:a17:906:3714:b0:92b:4f8e:dde1 with SMTP id d20-20020a170906371400b0092b4f8edde1mr11023545ejc.20.1678994690334; Thu, 16 Mar 2023 12:24:50 -0700 (PDT) Received: from localhost.localdomain (p50992f7c.dip0.t-ipconnect.de. [80.153.47.124]) by smtp.gmail.com with ESMTPSA id jx26-20020a170906ca5a00b008b1b86bf668sm21932ejb.4.2023.03.16.12.24.49 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 16 Mar 2023 12:24:50 -0700 (PDT) Message-ID: <47d0b525ad3ba570b4100e7b8d2a2b002ceba232.camel@cybertec.at> Subject: Re: EXTERNAL: Re: "No Free extents", table using all allocated space but no rows! From: Laurenz Albe To: "Dolan, Sean" , "pgsql-general@lists.postgresql.org" Date: Thu, 16 Mar 2023 20:24:49 +0100 In-Reply-To: <6eec8fc3dfa743ff9b19d8ce0e87763d@lmco.com> References: <0eda9b7d13e34cc786d30c602510f3e4@lmco.com> <6eec8fc3dfa743ff9b19d8ce0e87763d@lmco.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-03-16 at 13:20 +0000, Dolan, Sean wrote: > I messed up and confused issues.=C2=A0=C2=A0 The error is :=C2=A0=20 > ERROR: Could not extend pg_tblspc/16555/PG_13_20200/xxxx/xxxx=C2=A0 No sp= ace left on device > HINT: Check free disk space >=20 > So the schema is "full" and the offender is this one table. > I can't TRUNCATE as there needs to be space to perform the action. > Is there a way to see if there is a transaction on that table like you al= lude to? Ah, that's different. If you don't have enough space to run TRUNCATE, and you don't feel like extending the disk space, DROP TABLE would be a convenient alternative. Yours, Laurenz Albe