| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | nikonoid(at)gmail(dot)com |
| Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Comment about not being able to run ANALYZE on replicas |
| Date: | 2021-10-25 16:30:28 |
| Message-ID: | 4047078.1635179428@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
PG Doc comments form <noreply(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2021-10-26 00:19:29 | Re: The huge_pages parameter doesn't work when shared_memory_type is sysv |
| Previous Message | PG Doc comments form | 2021-10-25 10:19:53 | Comment about not being able to run ANALYZE on replicas |