Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s1RKI-00CKZB-O8 for pgsql-general@arkaria.postgresql.org; Mon, 29 Apr 2024 13:45:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s1RKG-00HHzJ-8q for pgsql-general@arkaria.postgresql.org; Mon, 29 Apr 2024 13:45:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s1RKF-00HHz4-Ti for pgsql-general@lists.postgresql.org; Mon, 29 Apr 2024 13:45:48 +0000 Received: from mail-wr1-x42f.google.com ([2a00:1450:4864:20::42f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s1RKE-000by7-D2 for pgsql-general@lists.postgresql.org; Mon, 29 Apr 2024 13:45:47 +0000 Received: by mail-wr1-x42f.google.com with SMTP id ffacd0b85a97d-346359c8785so3865925f8f.0 for ; Mon, 29 Apr 2024 06:45:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1714398345; x=1715003145; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=GkwCqtmjzT7f/gNXT55HE6kNwPWZT6BZqwp5OzE0SKU=; b=i7pM77LVIC1wlk4kCViltLDNb43ckVa5A/FYPm7IruYx/OJEXS/bR088XJLA6fcJm/ XVxdod6YNvduaCmenj/LD7MjUxXw6lMNnqMYzSLW5ZtPdKuH62lbSfACfe9ubaoDc+S4 P2nV1BzZ+IWcmbExoBDLs/ZTbQzoYkxL61O+mmqVBt/MCgsHctFp6bApG8EyKKVf+jOf DLq/N3WUandY0CdVh1t5zoZhAxn4uYplDgOeadqbY8ngqNM407WzLc9M+4pXNMqaHXUk U02RtVv8YdgohRAGXyATLdJGriAvCuprSdEUTYFpQA13Dq+xh7MeLYMOA9rBO5mpJ2/K m2Wg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1714398345; x=1715003145; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=GkwCqtmjzT7f/gNXT55HE6kNwPWZT6BZqwp5OzE0SKU=; b=N+nyWFReY6Bv1Ve++DwN57zRUIcUVWBpu8mVPIKihryCklWP9umHUsNB4n3ymVop42 Gcf8yFxKHG9mK3r2IciHl2FxVw839owIwZAVl5c0Yd1xr2N2jOiREc4bCXxnmZ6gRtkW EYEKKayUIyZSXhbDB7UrAkahDx0Z6/tzs0Oa/W5T5SMhLrepn9SZn/tp9C6OEJYtlMgv Jj5odH16gvh8JUX31RVFZJbVeRIvIeyeO4LkFQ6Y19eChBbI/h0LMiACzs8Cug4gB7k9 Lvr8oA/zMaya8C7//GLo5bINoaWw1FFJY2x+BH6kf9l7cG0hy7EPeguEM9ZUc46vrgey 6NFQ== X-Gm-Message-State: AOJu0Ywt+yZh+5zsKZYKdGUAbGw0n9QUqMifru/akUcqvq8EwzZfpmqA +NoLOvAevW7GxvyfIJkefq2fCQP8yPjubTV86BoFE9zsJ4uWbtOeVX7H0v3YFPfkGcacuTmNgqA euIz98G1GmsxIYmbIK+487FR67/05avsI X-Google-Smtp-Source: AGHT+IHPG9/xvIY0zRKIKmcYHG7P/7PVyg5c/h44WVzS6XlhpzVkCf8VVwgKv0lTxL34m5N/1ysQycxHYps0sCxsmkQ= X-Received: by 2002:a5d:5350:0:b0:34d:2427:40f2 with SMTP id t16-20020a5d5350000000b0034d242740f2mr1573819wrv.10.1714398344492; Mon, 29 Apr 2024 06:45:44 -0700 (PDT) MIME-Version: 1.0 From: "Cocam' server" Date: Mon, 29 Apr 2024 15:45:31 +0200 Message-ID: Subject: Need help to make space on my database To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000053bdc506173c78cc" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000053bdc506173c78cc Content-Type: text/plain; charset="UTF-8" Hello. I need help to make space on my database. I have tables that are several GB in size. I used to use the VACUUM FULL VERBOSE command; but now, this command is too greedy in free space to be used and I'm looking for a way to make free space (given back to the OS) Thanks in advance to everyone who responds --00000000000053bdc506173c78cc Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello.

I need help to make space on my database. I = have tables that are several GB in size. I used to use the VACUUM FULL VERB= OSE command; but now, this command is too greedy in free space to be used a= nd I'm looking for a way to make free space (given back to the OS)
<= br>Thanks in advance to everyone who responds
--00000000000053bdc506173c78cc--