On 31 July 2017 04:15:33 GMT+02:00, Alex Samad <alex@xxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
