"Trauma" is a very bad name because it sounds violent and extreme, so you can easily think it doesn't apply to you. In actual fact, it can be caused by something as routine as "sleep training" where infants are left to cry themselves to sleep, or being snapped at for expressing emotion, all before the age of 5. The years before 5 are foundational, but you usually no not have memories earlier than 5 so it's very hard to say definitely what happened especially when causes for trauma are relatively routine.
You need a trusted therapist to guide you into exposing what the subconscious mind is holding onto from infancy. It is subtle, deep, difficult, rewarding work. But I do think people discount trauma because it sounds scarier than "someone snapped at me in frustration as an infant for expressing some emotion and I learned to disconnect from myself."
The honest way to handle this, which hopefully your therapist does, is not to claim that you can magically retrieve perfect memories from before 5 because you thought about it hard. What matters is what your impression is of what happened and what messages your subconscious is sending you. Whether or not it literally happened isn't that important and it's impossible to know.
The therapeutic relief comes simply from listening to your gut/subconscious and feeling the emotions that that brings up. Being a loving friend and parent to that part of yourself. You can do that effectively without pretending that you can know if the impressions are literally true or if that message your getting is simply the best way for it to express the emotions it's holding onto.
Again, you can maintain your integrity while being empathic and loving and listening to the message.
You are advocating for some controversial positions in psychology, without naming them – something roughly along the lines of Gabor Maté, "inner child work", reparenting, "Internal Family Systems", etc
Many psychologists who belong to different schools of thought – e.g. CBT, positive psychology – don't agree those practices are helpful and don't agree with their theoretical underpinnings
There is a lack of high quality empirical evidence for both the safety and efficacy of the kinds of practices you advocate, and also for the theories which motivate them. By contrast, more mainstream approaches such as CBT have significantly better empirical support
A big reason the initial plan isn't guaranteed to be optimal, even with all the right indexes, is that table statistics aren't perfect. For example, you might track a column's correlation (how closely the column's logical ordering matches its physical ordering in the heap), but that won't be broken down at a per value level. Postal code X might be very correlated, while postal code Y that is used in your query is completely uncorrelated.
The ideal solution is to pick one plan initially, and then update a temporary query-specific statistic model based on the data you actually read while executing the query. Then periodically re-evaluate if an alternative plan would be faster, switching to it in a way that doesn't throw away the current partial result.
Of course switching plans mid flight is very complicated, but Oracle and SQL server both support this feature, so hopefully it lands in Postgres at some point.
It's been quite helpful when your project needs expertise from other people, and you want them to vet your approach and find gaps. Doing the up-front work of explaining the context and structuring the project in an easy to understand way makes it more likely for busy people to engage with it and help you out. Of course, it's helpful as a rubber-duck exercise on its own, so I would err on creating one, even if just for myself, for anything high-risk or hard to change later.
That's fine, but rate limiting is a solved problem at this point. They need to rate-limit free accounts and be realistic about their limits instead of letting the system fail.
Free (and non-free) accounts are already rate limited. The likely problem is that individual accounts/repos rarely hit those limits, instead the explosive demand is due to a massive growth in the number of small, individual projects being creatd.
You need a trusted therapist to guide you into exposing what the subconscious mind is holding onto from infancy. It is subtle, deep, difficult, rewarding work. But I do think people discount trauma because it sounds scarier than "someone snapped at me in frustration as an infant for expressing some emotion and I learned to disconnect from myself."