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 k
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 I
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
wrote:
> Hi Tomas- thank you for your thoughtful response!
>
>
> Tomas Vondra wrote
> > On 28.10.2014 21:55, jmcdonagh wrote:
> >> Hi, we have a n
