Re: [PERFORM] Big number of connections

2016-04-03 Thread Jim Nasby
On 4/1/16 2:54 AM, jarek wrote: I'll be happy to hear form users of big PostgreSQL installations, how many users do you have and what kind of problems we may expect. Is there any risk, that huge number of roles will slowdown overall performance ? The red flag from your original email was concer

Re: [PERFORM] Clarification on using pg_upgrade

2016-04-03 Thread Jim Nasby
On 3/24/16 12:43 PM, Tory M Blue wrote: Slon is also starting to not be viable as it takes some indexes over 7 hours to complete. So this upgrade path seemed to really be nice. If you're standing up a new replica from scratch on the latest version, I'm not really sure why that matters? Not