Re: [SPAM] Re: [PERFORM] Architectural question

2016-03-24 Thread Moreno Andreo
Il 23/03/2016 19:51, Jim Nasby ha scritto: On 3/23/16 4:14 AM, Moreno Andreo wrote: The main goal is to be *quick*. A doctor with a patient on the other side of his desk does not want to wait, say, 30 seconds for a clinical record to open. Let me explain what is the main problem (actually there

Re: [PERFORM] Clarification on using pg_upgrade

2016-03-24 Thread Tory M Blue
Thanks to all that responded I successfully upgraded 800GB DB with pg_upgrade in about 2 hours. This would have taken 2 days to dump/restore. 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. Not sure how I ca