Re: [GENERAL] streaming replication vacuum

2011-12-30 Thread Simon Riggs
On Sat, Dec 31, 2011 at 12:06 AM, Scott Marlowe wrote: > On Fri, Dec 30, 2011 at 5:03 AM, Magnus Hagander wrote: >> On Fri, Dec 30, 2011 at 07:35, dhaval jaiswal wrote: >>> >>> Might be discussed but not clear for the below query. >>> >>> In async. streaming replication do I need to run VACUUM &

Re: [GENERAL] streaming replication vacuum

2011-12-30 Thread Scott Marlowe
On Fri, Dec 30, 2011 at 5:03 AM, Magnus Hagander wrote: > On Fri, Dec 30, 2011 at 07:35, dhaval jaiswal 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 m

Re: [GENERAL] streaming replication vacuum

2011-12-30 Thread Magnus Hagander
On Fri, Dec 30, 2011 at 07:35, dhaval jaiswal 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 upd

[GENERAL] streaming replication vacuum

2011-12-29 Thread dhaval jaiswal
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. select last_vacuum, last_autovacuum, last_analyze, l