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.96) (envelope-from ) id 1vJzFy-00Atxa-1w for pgsql-admin@arkaria.postgresql.org; Fri, 14 Nov 2025 19:14:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vJzFv-007eNB-3B for pgsql-admin@arkaria.postgresql.org; Fri, 14 Nov 2025 19:14:47 +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.96) (envelope-from ) id 1vJzFv-007eN3-1n for pgsql-admin@lists.postgresql.org; Fri, 14 Nov 2025 19:14:47 +0000 Received: from mail-vs1-xe2e.google.com ([2607:f8b0:4864:20::e2e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vJzFt-0079DM-2T for pgsql-admin@lists.postgresql.org; Fri, 14 Nov 2025 19:14:46 +0000 Received: by mail-vs1-xe2e.google.com with SMTP id ada2fe7eead31-5dfa9e34adbso1747867137.0 for ; Fri, 14 Nov 2025 11:14:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1763147685; x=1763752485; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=UUD2/qW1C8aaSdypFFErmYxaDOILlqK7KwwEu325gBk=; b=i60d6o4j7/ucul1rLHdwoJOIMdhAw/P4NE0qeFWT39O9Mza9eOtFIeUdT0Gly91CA5 MEGWsvWGFDjEn13njByYL3UbxRLtwTqkumB/C7fsgb9E1bFgP+xa9mSBzEIW4K3QROaY C1lOs/6hJRtKCzARcv7xvDr9fkRKJe8KGcJECRKMij7Sx73eES6ACAhAc8XHMldV92tQ yzaoMkCP6QkMONB6cf/7VyRdMpYMBdhoPCoSy94rIaxLQMnCpcLLrt2CAPwJRxeU4XoE TOGJ6u3FAoGGFnCZEU5te+ubhpvb92Vmr6rScsDiNMMj8OWSQA/pTKQLiHZcHknSbrjp PEQw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763147685; x=1763752485; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=UUD2/qW1C8aaSdypFFErmYxaDOILlqK7KwwEu325gBk=; b=K0MB+elcJ1vQWOv4GS18ZHYg9CnbyooKHcb45f8M5QqUAyDc65b2f7VAjwan39UyhF Jq4aRvI1R0yjA+u7zFKfVoyCWIUmi0QTlFneioWL11Kdluxycl1DpDn4QyREhs/NRK9T 3jknYOuaTdzeOnFjv4Q8OSNE3Xj4b4UEo54I4StuDvxnaPAXGP7lGqcNJfRFsXCUiaBv zxPUXCrTZlI7/KCk1ECNXnlBrl9Kb/Dm2gU3D2M/0S3QBmDo8NtXwrn8DKv4e2eAc/T7 DxxSvHEY/fcTfVS5zL5P7VnijQoUVnhJ0PDAFrM7ToStQZTq22WhMwKXgyZniDq1NQh7 MzCQ== X-Gm-Message-State: AOJu0YzLfM/jLydeGY3npIcKcdDUO4DxEupPF9uOidPcqm+dhuYaJcIT IPJVLJNAYw4C6bgoDbT5UTiguGzkZuXPpsIhEV08V0w/u9h0IhKHpRL5KRzOCcjHmEKCHnlY78d d1qU2EgggSXYBqiR+bG/o7YwAKEF5gb+vnQ== X-Gm-Gg: ASbGnctCm1RyK9DNurArbC+txTVTsY4VRYwQ8tnFzET55goor/hPl3DZwKoN3VAkr2Z wSlOUsAPMhY2Vwnkcv5pulx5WCmXr0srzGKZtzrlSZnrKyFCd2j3FQm2O0BeyWP7myC0fu4feZM j9MK8GFq+jOLFRqMN5UK7vIQxXg0spdqPkQMAv5BDYZ15vLT4i4L20G10C06v2kX9a2WxOdTOsF XfZrra7DRxaqC+4gvyziOGM3W2V7jgPDr6uaDF64EJ5t2lse7yUTmx/g+O4jObDj8alg3L6BvjL WN3fCS1nrKr1SaPJWBE= X-Google-Smtp-Source: AGHT+IH5hKXPcY51nSX56lxVbA3N7I99z/u3S0GdLYBXmWFHJDU/oCotFQRGtsvf+2q48mS0Q6vsrrWYDmCz38N0oFg= X-Received: by 2002:a05:6102:41a2:b0:5db:d60a:6b1f with SMTP id ada2fe7eead31-5dfc5b727cbmr1892341137.23.1763147684897; Fri, 14 Nov 2025 11:14:44 -0800 (PST) MIME-Version: 1.0 From: ek ek Date: Fri, 14 Nov 2025 22:14:34 +0300 X-Gm-Features: AWmQ_bnbw_IlROA4T-ucb-GGDQt-oeP1qyts2oMzJM_8mcw4sb7SQpvx0GNe-Hk Message-ID: Subject: rebuild big tables with pgrepack To: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000071e67c064392cfb8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000071e67c064392cfb8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello everyone, I=E2=80=99m going to rebuild a 900GB table using pg_repack. I=E2=80=99m hes= itant to do such a large operation in one go. Is there an ideal or recommended way to repack very large tables? --00000000000071e67c064392cfb8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello everyone,
= I=E2=80=99m going to rebuild a 900GB table using pg_repack. I=E2=80=99m hes= itant to do such a large operation in one go.
Is the= re an ideal or recommended way to repack very large tables?
--00000000000071e67c064392cfb8--