On 31 July 2017 04:15:33 GMT+02:00, Alex Samad <[email protected]> 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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
