Re: [PERFORM] Incredibly slow restore times after 9.0>9.2 upgrade

2014-10-30 Thread Tomas Vondra
On 29.10.2014 16:12, 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 nightly job that restores current production data to >>> the development databases in a 'warm spare' database so that if th

Re: [PERFORM] Incredibly slow restore times after 9.0>9.2 upgrade

2014-10-30 Thread Jerry Sievers
jmcdonagh writes: > I just had a thought- I know some of these tables are in need of a vacuuming. > Could it be that the dump is dumping a bunch of garbage that the restore has > to sift through on the restore? I don't know enough details to know if this > is a dumb thought or not. No. However

Re: [PERFORM] Incredibly slow restore times after 9.0>9.2 upgrade

2014-10-30 Thread jmcdonagh
I just had a thought- I know some of these tables are in need of a vacuuming. Could it be that the dump is dumping a bunch of garbage that the restore has to sift through on the restore? I don't know enough details to know if this is a dumb thought or not. The restore to RDS took roughly the same