Re: [GENERAL] streaming replication vacuum

2011-12-30 Thread Magnus Hagander
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

Re: [GENERAL] streaming replication vacuum

2011-12-30 Thread Scott Marlowe
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.

Re: [GENERAL] streaming replication vacuum

2011-12-30 Thread Simon Riggs
On Sat, Dec 31, 2011 at 12:06 AM, Scott Marlowe scott.marl...@gmail.com wrote: 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.

[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,