Re: [PERFORM] Regarding Point-in-time Recovery feature

2015-02-23 Thread Mathis, Jason
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

Re: [PERFORM] Configuration tips for very large database

2015-02-12 Thread Mathis, Jason
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

Re: [PERFORM] Incredibly slow restore times after 9.09.2 upgrade

2014-10-29 Thread Mathis, Jason
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