| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | dhaval jaiswal <dhavallj(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: streaming replication vacuum |
| Date: | 2011-12-30 12:03:08 |
| Message-ID: | CABUevEySGifJJh8c+4YDTyB=u-qUT7jA+YBgfgjEU_UAO2vGuw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Dec 30, 2011 at 07:35, dhaval jaiswal <dhavallj(at)hotmail(dot)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.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2011-12-30 13:07:38 | Re: Verifying a timestamp is null or in the past |
| Previous Message | Cezariusz Marek | 2011-12-30 11:39:21 | How to get the time zone offset using to_char |