MIME-Version: 1.0
From: Koen De Groote <kdg.dev@gmail.com>
Date: Sun, 16 Jun 2024 00:55:50 +0200
Message-ID: <CAGbX52EwdrpPLyRuRRpnbhUqfQYijVz3cShSMuoXrs2Lgkod5Q@mail.gmail.com>
Subject: Is a VACUUM or ANALYZE necessary after logical replication?
To: PostgreSQL General <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e26ab8061af5a2ba"
Archived-At: <https://www.postgresql.org/message-id/CAGbX52EwdrpPLyRuRRpnbhUqfQYijVz3cShSMuoXrs2Lgkod5Q%40mail.gmail.com>
Precedence: bulk

--000000000000e26ab8061af5a2ba
Content-Type: text/plain; charset="UTF-8"

I've gone over all of
https://www.postgresql.org/docs/current/logical-replication.html and the
only mentions of the word "index" I could find was in relation to replica
identity and examples of table definitions showing primary key indexes.

Nothing is said about indexes. Maybe for good reason, maybe they are fully
functionality immediately after replication?

So the main question: Once a table is fully replicated, do I need to
vacuum(analyze) that table, or are the indexes on that table already
functional?

Regards,
Koen De Groote

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

<div dir=3D"ltr"><div>I&#39;ve gone over all of <a href=3D"https://www.post=
gresql.org/docs/current/logical-replication.html">https://www.postgresql.or=
g/docs/current/logical-replication.html</a> and the only mentions of the wo=
rd &quot;index&quot; I could find was in relation to replica identity and e=
xamples of table definitions showing primary key indexes.</div><div><br></d=
iv><div>Nothing is said about indexes. Maybe for good reason, maybe they ar=
e fully functionality immediately after replication?</div><div><br></div><d=
iv>So the main question: Once a table is fully replicated, do I need to vac=
uum(analyze) that table, or are the indexes on that table already functiona=
l?</div><div><br></div><div>Regards,</div><div>Koen De Groote<br></div></di=
v>

--000000000000e26ab8061af5a2ba--