On Fri, Dec 30, 2011 at 5:03 AM, Magnus Hagander <magnus@xxxxxxxxxxxx> wrote: > On Fri, Dec 30, 2011 at 07:35, dhaval jaiswal <dhavallj@xxxxxxxxxxx> wrote: >> >> Might be discussed but not clear for the below query. >> >> In async. streaming replication do I need to run VACUUM & ANALYZE on both >> master & slave. >> Bec, while querying on master getting below result, but slave's system table >> is not updated. > > You run VACUUM and ANALYZE on the master only, and the results are > automatically replicated to the slave. > > However, the *statistics views* on the slave are not updated. That's > why it looks like it's not been run, even though it has. Given the use of hot spares in this setup, wouldn't that kind of be a bug that they're not updated? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
