Re: [PERFORM] Clarification on using pg_upgrade

2016-04-19 Thread Tory M Blue
In line Jim On Sun, Apr 3, 2016 at 10:13 AM, Jim Nasby wrote: > 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

Re: [PERFORM] Hash join seq scan slow

2016-04-19 Thread Jeff Janes
On Tue, Apr 19, 2016 at 1:07 AM, Aldo Sarmiento wrote: > Hello, > > I'm assuming this topic has probably been bludgeoned to a pulp, but my > google-fu can't seem to find a solution. > > I have two relatively largish tables that I'm trying to join that result in > a slow query. > > Hardware: > > 20

[PERFORM] Hash join seq scan slow

2016-04-19 Thread Aldo Sarmiento
Hello, I'm assuming this topic has probably been bludgeoned to a pulp, but my google-fu can't seem to find a solution. I have two relatively largish tables that I'm trying to join that result in a slow query. Hardware: 2014 iMac w/ SSD & i5 processor Tables: contacts: 1.14 million rows permiss