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.
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.