MIME-Version: 1.0
References: <CAKna9VaOt_FPSSdMQaF0abiAPLdN1jB9renORV+ky2mP1_nDRw@mail.gmail.com>
 <CAD=mzVXtgnFxk0uE6=yaJX8JYY6kt4UiUc-kqi=MyUOCmWp3hg@mail.gmail.com>
In-Reply-To: <CAD=mzVXtgnFxk0uE6=yaJX8JYY6kt4UiUc-kqi=MyUOCmWp3hg@mail.gmail.com>
From: Lok P <loknath.73@gmail.com>
Date: Sun, 9 Jun 2024 10:39:01 +0530
Message-ID: <CAKna9VYFnmcj0m4FtfMsEQbW8-5QSg8=najLbs-DBHMwtDR=DQ@mail.gmail.com>
Subject: Re: Creating big indexes
To: sud <suds1434@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a71b41061a6e0858"
Archived-At: <https://www.postgresql.org/message-id/CAKna9VYFnmcj0m4FtfMsEQbW8-5QSg8%3DnajLbs-DBHMwtDR%3DDQ%40mail.gmail.com>
Precedence: bulk

--000000000000a71b41061a6e0858
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sun, Jun 9, 2024 at 10:36=E2=80=AFAM sud <suds1434@gmail.com> wrote:

>
>  You can first create the index on the table using the "On ONLY"keyword,
> something as below.
>
> CREATE INDEX idx ON ONLY tab(col1);
>
> Then create indexes on each partition in "concurrently" from multiple
> sessions in chunks.
>
> CREATE INDEX CONCURRENTLY idx_1    ON tab_part1(col1);
> CREATE INDEX CONCURRENTLY idx_2    ON tab_part2(col1);
>
> After this step finishes the table level index which was created in the
> first step will be in valid state automatically.
>
>
Thank you so much.
Should we also tweak the parameters related to the parallelism and memory
as I mentioned in the first post?

--000000000000a71b41061a6e0858
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Sun, Jun 9, 2024 at 10:36=E2=80=AF=
AM sud &lt;<a href=3D"mailto:suds1434@gmail.com">suds1434@gmail.com</a>&gt;=
 wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px =
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=
=3D"ltr"><div dir=3D"ltr"><br></div><div class=3D"gmail_quote"><div>=C2=A0Y=
ou can first create the index on the table using the &quot;On ONLY&quot;key=
word, something as below.</div><div><br></div><div>CREATE INDEX idx ON ONLY=
 tab(col1);<br></div><div><br></div><div>Then create indexes on each partit=
ion in &quot;concurrently&quot; from multiple sessions in chunks.</div><div=
><br></div><div>CREATE INDEX CONCURRENTLY idx_1=C2=A0 =C2=A0 ON tab_part1(c=
ol1);<br>CREATE INDEX CONCURRENTLY idx_2=C2=A0 =C2=A0 ON tab_part2(col1);<b=
r></div><div><br></div><div>After this step finishes the table level index =
which was created in the first step will be in valid state automatically.</=
div><div><br></div></div></div></blockquote><div><br></div><div>Thank you s=
o much.</div><div>Should we also tweak the parameters related to the parall=
elism and memory as I mentioned in the first post?=C2=A0</div></div></div>

--000000000000a71b41061a6e0858--