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 1qacea-009uEf-IR for pgsql-general@arkaria.postgresql.org; Mon, 28 Aug 2023 13:51:40 +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 1qaceZ-00CYeh-Fh for pgsql-general@arkaria.postgresql.org; Mon, 28 Aug 2023 13:51:39 +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 1qaceZ-00CYe2-2P for pgsql-general@lists.postgresql.org; Mon, 28 Aug 2023 13:51:38 +0000 Received: from mail-ej1-x633.google.com ([2a00:1450:4864:20::633]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qaceW-001QJk-9Z for pgsql-general@postgresql.org; Mon, 28 Aug 2023 13:51:37 +0000 Received: by mail-ej1-x633.google.com with SMTP id a640c23a62f3a-99c1c66876aso416376366b.2 for ; Mon, 28 Aug 2023 06:51:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1693230694; x=1693835494; h=to:message-id:subject:date:mime-version:from :content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=83DH8AiK67ZalMD1Bnzh2rdv0XoqcZwZJRVpCjLnJuQ=; b=FFsrTdcGwbJWlgoqPrlgAxAwT6X/7pZ2NvMOqOQctEZE9kwuzIa2tuHb1yiaUBlGvw 3kt31mlR87qBlHD1DrI21ybI++x+m/6uWbJzzb1tF3s5PRCxNVe2tTqOtxPPCnAfnxDR Lk+EV+RQeMWo/hPjDt+WJOdYgTUTLcJxFqEx+nEYPvoF1MGSXmxvJ1lRzwcpC0YeH8kh pVOIKg761yTnSExvUPYsVaao7J2WEZiRmVt8NJVs5qbTNvDTgLDVxJHsjGouC/i77EKS sciGKRq2DMl+JtWZPyAr8q6qN2BQc6iyptPkamwxEPxZ6Yde+b9rc+/agrml6U0DNS8R Ex5A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693230694; x=1693835494; h=to:message-id:subject:date:mime-version:from :content-transfer-encoding:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=83DH8AiK67ZalMD1Bnzh2rdv0XoqcZwZJRVpCjLnJuQ=; b=XAcF8xfSr7oyg4A6q8FHjz6bDDNK1GcxQB0A4xLUJlAFrtmHLE3BnzC/qMOjaUTf03 +qpEb1rbZjo2oCO4qli9TMUIDw+zlC6t9RcQjdS++fVN6VaQIBJZq+lMlfsHEG0Cmp4J DNzpmGKafZf93/Ykirl/036gUOrDJYGBw4kCozwIFl0Tstnm/V5xgeE+Sys11ug8ip72 HWaIeHAXMMqwAF1BH6ur52an3KrLL+5n+zLt1UtMzqnSt5hgszsuAdZSLx7xPx2JC7Hf I5gJR3mMNRUsRe/SRMkqKTzw1hX+zp06LDZuOB+H8iRLdTuBoekwWaVrUmOczWCZ9JuI LcjQ== X-Gm-Message-State: AOJu0Yzy+kOnps4WCnmXJ3ijdQLVHuzvMdQKTtHg3MVD25QbtKpqraGr NMBw6xx+mmqMXtaFcDI3soWPlgd0654= X-Google-Smtp-Source: AGHT+IFxT7N1IMFK+caX0omRz3WuJMhAT6SmwYqKAdt00F/tWtOadJE1spqKJKKDVIT35c3R17MJ6Q== X-Received: by 2002:a17:906:5a46:b0:9a1:cb2c:b55f with SMTP id my6-20020a1709065a4600b009a1cb2cb55fmr12667077ejc.53.1693230694240; Mon, 28 Aug 2023 06:51:34 -0700 (PDT) Received: from smtpclient.apple ([185.170.224.189]) by smtp.gmail.com with ESMTPSA id y16-20020a1709064b1000b009a1dbf55665sm4655006eju.161.2023.08.28.06.51.33 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 28 Aug 2023 06:51:33 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-E1DE2F74-3DDE-4808-AC9B-FB574BB573FE Content-Transfer-Encoding: 7bit From: Joseph Kennedy Mime-Version: 1.0 (1.0) Date: Mon, 28 Aug 2023 15:51:22 +0200 Subject: PostgreSQL 12 reindex Message-Id: <0F563B62-60D3-4887-8807-12EE96F06D26@gmail.com> To: pgsql-general@postgresql.org X-Mailer: iPhone Mail (20G75) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-E1DE2F74-3DDE-4808-AC9B-FB574BB573FE Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit How to safely perform a reindex partitioned tables (postgresql 12) Regards, Jk --Apple-Mail-E1DE2F74-3DDE-4808-AC9B-FB574BB573FE Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit How to safely perform a reindex  partitioned tables (postgresql 12)

Regards,
Jk


--Apple-Mail-E1DE2F74-3DDE-4808-AC9B-FB574BB573FE--