I'm looking to extend my PostgreSQL 9.4 master with a few slaves in hot
standby read-only for load balancing.
The idea would be to update the slaves only at defined times (once every
24/48 hours) to avoid migration issues with the application server code
and also because the "freshness" of the slaves is not so important.
What would be the effect of suddenly introducing a 1-2 GB of WAL
archives to the WAL restore folder on the slave? Would there be a big
performance effect on the incoming queries to the slave? Would the slave
be available for queries while the WAL logs are restored into the DB?
Thanks
Jordi
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
