Re: [PERFORM] Slow query after 9.3 to 9.6 migration

2017-01-05 Thread Flávio Henrique
strategy. > I do see some suspicious casting, for example: > Join Filter: ((four_charlie.delta_tango)::integer = > (six_quebec.golf_bravo)::integer) > Are you casting in the query or joining through dissimilar data types? No casts in query. The joins are on same data types. Thank you

[PERFORM] Slow query after 9.3 to 9.6 migration

2016-12-27 Thread Flávio Henrique
ated (even from the query side). Thank you! The query plan: https://explain.depesz.com/s/5KMn Note: I tried to add index on kilo_victor table already, but Postgresql still thinks that is better to do a seq scan. Flávio Henrique