Matthew T. O'Connor wrote:
Florian G. Pflug wrote:
Work done so far:
.) Don't start autovacuum and bgwriter.

Do table stats used by the planner get replicated on a PITR slave? I assume so, but if not, you would need autovac to do analyzes.

Yes - everything that get wal-logged on the master gets replicated to
the slave. In my design, it isn't possible to do "analyze" on the slave,
because all datafiles are strictly readonly (well, with the small
exception of hit-bit updates actually).

greetings, Florian Pflug

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to