On 31 July 2017 04:15:33 GMT+02:00, Alex Samad <alex(at)samad(dot)com(dot)au> wrote:
>Hi
>
>setup a cluster, with streaming replication and hot stand by
>
>the idea is to use the stand by to do queries whilst the primary is
>doing
>inserts.
>
>But I noticed the stats on the stand by server don't update, nor can I
>run
>vacuum against it as its in recovery mode.
>
>So how do update the stats and how will it affect my queries ?
The standby is read only, vacuum runs on the master and replicated to the standby. Analyse as well.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company