Re: [PERFORM] Slow query with 3 table joins

2017-04-26 Thread Alessandro Ferrucci
t;P_RACE2_MEXICAN_IND";1447812 "P_RACE2_MOROCCAN_IND";1447812 "P_RACE2_NATHAWAIIAN_IND";1447812 "P_RACE2_NHPI_TEXT";1447812 "P_RACE2_NIGERIAN_IND";1447812 "P_RACE2_POLISH_IND";1447812 "P_RACE2_PUERTORICAN_IND";1447812 "P_RAC

Re: [PERFORM] Slow query with 3 table joins

2017-04-26 Thread Alessandro Ferrucci
Rowley wrote: > On 26 April 2017 at 15:19, Alessandro Ferrucci > wrote: > > After about 40 inutes the slow query finally finished and the result of > the > > EXPLAIN plan can be found here: > > > > https://explain.depesz.com/s/BX22 > > > Index Scan us

Re: [PERFORM] Slow query with 3 table joins

2017-04-26 Thread Alessandro Ferrucci
S datatype to a varchar(250), but that did not affect the performance of the query. On Wed, Apr 26, 2017 at 2:24 AM, Johan Fredriksson wrote: > tis 2017-04-25 klockan 23:19 -0400 skrev Alessandro Ferrucci: > > After about 40 inutes the slow query finally finished and the result > &

Re: [PERFORM] Slow query with 3 table joins

2017-04-25 Thread Alessandro Ferrucci
After about 40 inutes the slow query finally finished and the result of the EXPLAIN plan can be found here: https://explain.depesz.com/s/BX22 Thanks, Alessandro Ferrucci On Tue, Apr 25, 2017 at 11:10 PM, Alessandro Ferrucci < alessandroferru...@gmail.com> wrote: > Hello - I am mi

[PERFORM] Slow query with 3 table joins

2017-04-25 Thread Alessandro Ferrucci
uum settings, but since the tables are static for now and I've already ran VACUUM that should not have any effect. Any assistance that could be provided is greatly appreciated. Thank you, Alessandro Ferrucci