SQL

i am tired of seeing junior devs slapping b tree indexes on every single column because they read a medium article from 2015. you are just bloating your storage and killing your write throughput for queries that run once a week. unless you have a high cardinality column being fil…

why is it that i spend 80% of my time optimizing complex dags only for the root cause of the failure to be a single missing index in postgres? it feels like we are doing advanced data science in the front and playing whack a mole with sql performance in the back. just adds 5 seco…