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 1qacsT-009v1A-JP for pgsql-general@arkaria.postgresql.org; Mon, 28 Aug 2023 14:06:01 +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 1qacsS-00Ciej-CA for pgsql-general@arkaria.postgresql.org; Mon, 28 Aug 2023 14:06:00 +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 1qacsR-00CieW-S7 for pgsql-general@lists.postgresql.org; Mon, 28 Aug 2023 14:05:59 +0000 Received: from mail-ej1-x635.google.com ([2a00:1450:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qacsK-001QQk-Ri for pgsql-general@postgresql.org; Mon, 28 Aug 2023 14:05:58 +0000 Received: by mail-ej1-x635.google.com with SMTP id a640c23a62f3a-9a21b6d105cso416051066b.3 for ; Mon, 28 Aug 2023 07:05:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1693231551; x=1693836351; h=to:in-reply-to:references:message-id:date:subject:mime-version:from :content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=F20vgPs0u6W6h2QBZH/BRZWVdzXWTHjAIz3oMifsWxI=; b=oQUZJz+dopv9rc7q/+PqCCUbgCYsd2NDQSNJUJ2qSqjwE+SYOT4iJ/uN3OwzBD3qc5 s5500FUBqq7i676Ey7GSH5MYnyXKkebkMPHHMDWBvpHkE6XrrUwulHF8Y3B0Xb2fdQxQ iwlPfVxDW7Ju5iwio4gtqvdlxhADJfhXKXlmzPZmUsNd6WrfnqncGOa4yemZDk0DFIWc QstFeS/1h3GGoXWHe3aWpB8LviYPrDi48kKyZFflzGr3xPgUMVmsuJ05FPX8X8WyktKh WmFUXiD8CLFwRiT+PUVq5HoNqO6NoKzQ70pyi3japBH5FxV6uodEATIlUPH9HTJyqqPe xobA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693231551; x=1693836351; h=to:in-reply-to:references:message-id:date:subject:mime-version:from :content-transfer-encoding:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=F20vgPs0u6W6h2QBZH/BRZWVdzXWTHjAIz3oMifsWxI=; b=XF6FlVKXTI1UMOzzWdHrmE0ZPk4o8TppmfrBmuK+vC1LfFpOHy4escsrUATsbg4jqH 3doGg8/WWJhUMqn6H6MegIIKRLA2hwjEYpypiXkdiGV/l83PUHz2Vi3/e0cFEMVbIp9t HcgWU9ZAFF2Oh3HAwJmwtNw5kelg0dWbgUzGHrqR4rBU6FYSIRoVXRSR6zN2Zb6Vhv3s rgjxyEBRKiqBvrEf1k3t+lxLDvNGU/ZJoK8uNTh0WqxofQX847qI5Q9a7T/BixUVbKjO b5zDKkKvAnxinrrdS2qXWOx0IwIiNWUTZOkAP86v3/1uzm/sOBrOPSbpBjANTX5gonkZ bYtA== X-Gm-Message-State: AOJu0Ywr/y83P04+brB+qXoly7aZqF3RDsNKynm614VuHzIisXZsxq8d PYyw69Qa84ODUd6HkWDi/4CkYO3FuKU= X-Google-Smtp-Source: AGHT+IHJYDX7h3hu5b7CGldVDzYi14tj1VN4w8t36JImBrN9VJzSDGQo872J5zGJD7rg5vcGTX7I4w== X-Received: by 2002:a17:906:73ca:b0:9a1:f21e:cdff with SMTP id n10-20020a17090673ca00b009a1f21ecdffmr11569687ejl.23.1693231551048; Mon, 28 Aug 2023 07:05:51 -0700 (PDT) Received: from smtpclient.apple ([185.170.224.189]) by smtp.gmail.com with ESMTPSA id b10-20020a170906490a00b009a1fef32ce6sm4741190ejq.177.2023.08.28.07.05.50 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 28 Aug 2023 07:05:50 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-6CCFED62-5D70-444C-89CA-F76430C8F1A8 Content-Transfer-Encoding: 7bit From: Joseph Kennedy Mime-Version: 1.0 (1.0) Subject: Re: PostgreSQL 12 reindex Date: Mon, 28 Aug 2023 16:05:39 +0200 Message-Id: <5F41E4AC-317B-4563-9108-93FFABF3349D@gmail.com> References: <0F563B62-60D3-4887-8807-12EE96F06D26@gmail.com> In-Reply-To: <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-6CCFED62-5D70-444C-89CA-F76430C8F1A8 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable It=E2=80=99s good idea do that like this: REINDEX TABLE CONCURRENTLY partitioned_table_1 REINDEX TABLE CONCURRENTLY partitioned_tab_2=20 REINDEX TABLE CONCURRENTLY partitioned_table_3 Regards, JK > Wiadomo=C5=9B=C4=87 napisana przez Joseph Kennedy w dniu 28.08.2023, o godz. 15:51: >=20 > =EF=BB=BFHow to safely perform a reindex partitioned tables (postgresql 1= 2) >=20 > Regards, > Jk >=20 >=20 --Apple-Mail-6CCFED62-5D70-444C-89CA-F76430C8F1A8 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable It=E2=80=99s good idea do that like this:

REINDEX TABLE CONCURRENTLY partitioned_= table_1


REINDEX TABLE CONCURRENTLY partitioned_tab_2 


REINDEX T= ABLE CONCURRENTLY partitioned_table_3


Re= gards,
JK

Wiadom= o=C5=9B=C4=87 napisana przez Joseph Kennedy <joseph.kennedy.486@gmail.com= > w dniu 28.08.2023, o godz. 15:51:

<= blockquote type=3D"cite">
=EF=BB=BFHow to safely perform a reindex  partitio= ned tables (postgresql 12)

= Regards,
Jk


= --Apple-Mail-6CCFED62-5D70-444C-89CA-F76430C8F1A8--