5 ms·

I think if you're joining against wrong tables or columns, then you have bigger problems than if the values are BigInt or UUID's.

• sk5t 5y ago
  "Don't ever be wrong" is one way to do it; on the other hand, sometimes we make mistakes anyway, especially in ad hoc queries, and not getting any results back at all helps to spot the problem quickly (more quickly than spending minutes befuddled by the nonempty resultset).
  • eric4smith 5y ago
    One thing that no one mentions so far is the extra space these ids consume. Is the value of making that mistake strong enough that you use so much more data to store a UUID value??
    • sk5t 5y ago
      Well, I in fact did mention the "compactness" of integers at the start of this thread :)