[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: PostgreSQL 12 reindex
From: Joseph Kennedy <joseph.kennedy.486 () gmail ! com>
Date: 2023-08-28 14:05:39
Message-ID: 5F41E4AC-317B-4563-9108-93FFABF3349D () gmail ! com
[Download RAW message or body]
It's good idea do that like this:
REINDEX TABLE CONCURRENTLY partitioned_table_1
REINDEX TABLE CONCURRENTLY partitioned_tab_2
REINDEX TABLE CONCURRENTLY partitioned_table_3
Regards,
JK
> Wiadomość napisana przez Joseph Kennedy <joseph.kennedy.486@gmail.com> w dniu \
> 28.08.2023, o godz. 15:51:
> How to safely perform a reindex partitioned tables (postgresql 12)
>
> Regards,
> Jk
>
>
[Attachment #3 (text/html)]
<html><head><meta http-equiv="content-type" content="text/html; \
charset=utf-8"></head><body dir="auto">It's good idea do that like \
this:<div><br></div><div><p class="p1" style="margin: 0px; font-stretch: normal; \
line-height: normal; font-size-adjust: none; font-kerning: auto; \
font-variant-alternates: normal; font-variant-ligatures: normal; \
font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: \
normal; font-feature-settings: normal; font-optical-sizing: auto; \
font-variation-settings: normal; caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); \
-webkit-text-size-adjust: auto;"><span class="s1">REINDEX TABLE CONCURRENTLY \
partitioned_table_1</span></p><p class="p2" style="margin: 0px; font-stretch: normal; \
line-height: normal; font-size-adjust: none; font-kerning: auto; \
font-variant-alternates: normal; font-variant-ligatures: normal; \
font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: \
normal; font-feature-settings: normal; font-optical-sizing: auto; \
font-variation-settings: normal; min-height: 22px; caret-color: rgb(0, 0, 0); color: \
rgb(0, 0, 0); -webkit-text-size-adjust: auto;"><span class="s1"></span><br></p><p \
class="p1" style="margin: 0px; font-stretch: normal; line-height: normal; \
font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; \
font-variant-ligatures: normal; font-variant-numeric: normal; \
font-variant-east-asian: normal; font-variant-position: normal; \
font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: \
normal; caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); -webkit-text-size-adjust: \
auto;"><span class="s1">REINDEX TABLE CONCURRENTLY \
partitioned_tab_2 </span></p><p class="p2" style="margin: 0px; font-stretch: \
normal; line-height: normal; font-size-adjust: none; font-kerning: auto; \
font-variant-alternates: normal; font-variant-ligatures: normal; \
font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: \
normal; font-feature-settings: normal; font-optical-sizing: auto; \
font-variation-settings: normal; min-height: 22px; caret-color: rgb(0, 0, 0); color: \
rgb(0, 0, 0); -webkit-text-size-adjust: auto;"><span class="s1"></span><br></p><p \
class="p1" style="margin: 0px; font-stretch: normal; line-height: normal; \
font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; \
font-variant-ligatures: normal; font-variant-numeric: normal; \
font-variant-east-asian: normal; font-variant-position: normal; \
font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: \
normal; caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); -webkit-text-size-adjust: \
auto;"><span class="s1">REINDEX TABLE CONCURRENTLY \
partitioned_table_3</span></p></div><div><br></div><div>Regards,</div><div>JK<br><div \
dir="ltr"><br><blockquote type="cite">Wiadomość napisana przez Joseph Kennedy \
<joseph.kennedy.486@gmail.com> w dniu 28.08.2023, o godz. \
15:51:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><meta \
http-equiv="content-type" content="text/html; charset=utf-8"><span \
style="-webkit-text-size-adjust: auto; caret-color: rgb(0, 0, 0); color: rgb(0, 0, \
0); background-color: rgb(255, 255, 255);">How to safely perform a reindex \
partitioned tables (postgresql 12)</span><div><font color="#000000"><span \
style="caret-color: rgb(0, 0, 0); -webkit-text-size-adjust: auto; background-color: \
rgb(255, 255, 255);"><br></span></font></div><div><font color="#000000"><span \
style="caret-color: rgb(0, 0, 0); -webkit-text-size-adjust: auto; background-color: \
rgb(255, 255, 255);">Regards,</span></font></div><div><font color="#000000"><span \
style="caret-color: rgb(0, 0, 0); -webkit-text-size-adjust: auto; background-color: \
rgb(255, 255, 255);">Jk<br></span></font><div><br><div \
dir="ltr"><br></div></div></div></div></blockquote></div></body></html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic