News for hackers. Stuff that matters.
Re:Working around a case where the Postgres planner is “not ... by kmdupree on Monday August 02, 2021 @03:20PM (#28041369)
You're exactly right that our schema could be better and that it's non-trivial to execute on a schema change, especially because we actually run a distributed Postgres cluster via Citus AND we use a special sharding method that we manage manually.

We actually just started working towards how we might do a schema change for the 1+ million shards in our cluster. Hopefully, we'll be able to write up some learnings on the schema change after its done. :)

Re:Working around a case where the Postgres planner is “not ... by mst on Tuesday August 03, 2021 @04:23PM (#28053686)
Right, your current solution is what I'd classify as an "expedient field hack" if I were the one implementing it, and I do mean that positively :D

I look forwards to comparing notes when that post comes out.