pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedreindex database
2+ messages / 2 participants
[nested] [flat]
* reindex database
@ 2020-06-28 20:42 PG Doc comments form <noreply@postgresql.org>
2020-06-29 14:44 ` Re: reindex database Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2020-06-28 20:42 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: andreibancila@yahoo.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/sql-reindex.html
Description:
Hello,
I am using this command to reindex the databases for a PostgreSQL 10
cluster.
What I can not find in the reindex explanation page is how is this affecting
the standby database. I tracked the log creation on the Primary cluster but
I saw nothing like this on the Standby cluster.
I was able to find the following statement on the hot-standby description
page (26.5. Hot Standby) from the documentation:
"As a result, you cannot create additional indexes that exist solely on the
standby, nor statistics that exist solely on the standby. If these
administration commands are needed, they should be executed on the primary,
and eventually those changes will propagate to the standby."
(https://www.postgresql.org/docs/10/hot-standby.html)
Can you please tell me more on this topic or point me to the documentation
page that explained more on this topic (database reindex - synching with the
standby cluster and impact on the standby cluster).
Thank you,
Andrei Bancila
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: reindex database
2020-06-28 20:42 reindex database PG Doc comments form <noreply@postgresql.org>
@ 2020-06-29 14:44 ` Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2020-06-29 14:44 UTC (permalink / raw)
To: andreibancila@yahoo.com; pgsql-docs@lists.postgresql.org
On Sun, Jun 28, 2020 at 08:42:10PM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/10/sql-reindex.html
> Description:
>
> Hello,
> I am using this command to reindex the databases for a PostgreSQL 10
> cluster.
> What I can not find in the reindex explanation page is how is this affecting
> the standby database. I tracked the log creation on the Primary cluster but
> I saw nothing like this on the Standby cluster.
> I was able to find the following statement on the hot-standby description
> page (26.5. Hot Standby) from the documentation:
> "As a result, you cannot create additional indexes that exist solely on the
> standby, nor statistics that exist solely on the standby. If these
> administration commands are needed, they should be executed on the primary,
> and eventually those changes will propagate to the standby."
> (https://www.postgresql.org/docs/10/hot-standby.html)
> Can you please tell me more on this topic or point me to the documentation
> page that explained more on this topic (database reindex - synching with the
> standby cluster and impact on the standby cluster).
> Thank you,
> Andrei Bancila
For full-cluster, non-logical replication, the data files on the primary
and replicas have to be identical, so any reindex on the primary
generates replayed WAL records to the replica to recreate the index.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-06-29 14:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-06-28 20:42 reindex database PG Doc comments form <noreply@postgresql.org>
2020-06-29 14:44 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox