Full explanation starts here:
http://www.postgresql.org/docs/9.3/static/continuous-archiving.html.
While there are some considerations to take in it does not relate to
performance. Generally most production systems run with archiving on. Take
a minute to read through the documentation and let us
I can't speak to the numbers postgresql can or cannot do but the numbers
above sound very very doable. If you can get a hold of *greg smith's
postgresql high performance*, I always liked his method of tuning buffers
and checkpoints using the background writer stats. All of which can help
with the
Is the instance ebs-optimized? I am wondering if its a configuration on the
instance not postgres or ebs.
On Wed, Oct 29, 2014 at 10:12 AM, jmcdonagh joseph.e.mcdon...@gmail.com
wrote:
Hi Tomas- thank you for your thoughtful response!
Tomas Vondra wrote
On 28.10.2014 21:55, jmcdonagh