On Fri, Dec 30, 2011 at 5:03 AM, Magnus Hagander <magnus@hagander.net> wrote:
> On Fri, Dec 30, 2011 at 07:35, dhaval jaiswal <dhavallj@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?