On Fri, Dec 30, 2011 at 5:03 AM, Magnus Hagander <mag...@hagander.net> wrote: > On Fri, Dec 30, 2011 at 07:35, dhaval jaiswal <dhava...@hotmail.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
