Re: [GENERAL] Shipping big WAL archives to hot standby

2016-04-10 Thread Venkata Balaji N
> 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? > If the Que

[GENERAL] Shipping big WAL archives to hot standby

2016-04-08 Thread Jordi
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