pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedComment about not being able to run ANALYZE on replicas
2+ messages / 2 participants
[nested] [flat]
* Comment about not being able to run ANALYZE on replicas
@ 2021-10-25 10:19 PG Doc comments form <noreply@postgresql.org>
2021-10-25 16:30 ` Re: Comment about not being able to run ANALYZE on replicas Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2021-10-25 10:19 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: nikonoid@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/sql-analyze.html
Description:
https://www.postgresql.org/docs/12/sql-analyze.html does not have anything
about not being able to run ANALYZE on replicas.
I now understand that this is because statistics are stored in a table, and
that table is replicated from primary server to the replica, but it would be
helpful to have something about this in the official documentation.
Thanks,
Niko.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Comment about not being able to run ANALYZE on replicas
2021-10-25 10:19 Comment about not being able to run ANALYZE on replicas PG Doc comments form <noreply@postgresql.org>
@ 2021-10-25 16:30 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2021-10-25 16:30 UTC (permalink / raw)
To: nikonoid@gmail.com; +Cc: pgsql-docs@lists.postgresql.org
PG Doc comments form <noreply@postgresql.org> writes:
> https://www.postgresql.org/docs/12/sql-analyze.html does not have anything
> about not being able to run ANALYZE on replicas.
> I now understand that this is because statistics are stored in a table, and
> that table is replicated from primary server to the replica, but it would be
> helpful to have something about this in the official documentation.
I'm a little skeptical about that. By that argument, nearly every one
of our SQL command pages would need a disclaimer saying that you can't
use it on a replica.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-10-25 16:30 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-10-25 10:19 Comment about not being able to run ANALYZE on replicas PG Doc comments form <noreply@postgresql.org>
2021-10-25 16:30 ` Tom Lane <tgl@sss.pgh.pa.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