2 pointsby ClaudiuDasca7 hours ago1 comment
  • ClaudiuDasca7 hours ago
    Author here. Timing is unrelated, but Clerk’s postmortem mentioned something I didn't ,cover enough in the post: the planner.

    If I understood correctly, auto-analyze sampled a column that was 99.9996% NULL, and rounded that up to “effectively all NULL”.

    I’ve seen threads about migrating from Postgres that boil down to planner surprises. Curious if others have hit similar cases, and what the practical mitigation was.