The brain mostly follow the money and that inflates the salary for everyone in that area.
The very talented individuals who stay "home" get pretty much the same pay the individual Whould in an inflated area, but the individuals peers don't.
I think the inflation which happens in pretty much every large city with a thriving tech/startup environment, is largely due to the fact that lage groups of highly skilled and talented people gather and then that super salary becomes "normal" and then the rest wants an even salary. Lowering the tops pay is a no go as that salary they can get literally in any geographic location. Then the only thing left is base pay has to go up.
Makes sense, just like for cern and probably several other previously free riders that's being removed.
MS is going for a personal subscription based lisencing solution in the near future.
If you think office is a cash cow think what windows whould be, every company whould boy this for their employers, the employers when fired e.g without a job whould buy it so that they can log in to their machine and so on. They could easily fetch 5$ a month from about a billion people if not more. Pluss servers being maybe 100$ a moth per server per company and so on.
Allowing MS to capitalize and companies being able to easier shape their own usage.
And some whould argue... A lot of people will move to Linux (no they wont (some but not a lot) simply because for most people it looks, feels and works like something made in someone's garage.
Well AMD has a "death grip" in the console market. That's kind of their equivalent. If they gain access and spit the Intel monopoly in the laptop market then AMD can become Intel faster than anyone could think of.
Anorexia heard of it. That's what happens if you choose not to eat. Yes you die but it is a choice (ish, a desease? yes, but stil a choice(of madness)).
Being a parent is time forcefully spent. Now one could argue that all free time for a parent of children below a certain age is parenting time,and thus it might make sense to have a checkbox rather than a time slider for parenting time. The point is a parents free time is non existant we simply cannot play games on a pc or code for an extended period of time on weekends or holidays because that comes at the cost of not monitoring your child's daily consumption of soap (it should be zero, but you will be amased), or you could lock them in a padded room (illegal) so that you can code/game whatever in peace.
The point is, a child makes sure that you never have a split second while they are awake to do what you want because they will literally sit on your hands and pull your hair (and you will come to love it in a bizarre way) that's just how it is (for a while)
The only way for the society to learn is by doing. We need people who are gifted and have no grit and people who are not gifted but has.
Also don't tell every child they can become anything, they can not. I suggest telling them "they can do anything they set their mind to but they need to want it" that last part is the grit part, gifted people me as well hits a wall at some time in life where the rules and systems (job) do not fall naturally like coursework, here you have two choices stand up and do your job (just know, you will succed it just takes some more time than usual), or don't and be bad at your job and don't excell.
Whining about what you where not taught Fron society or parents gets you nowhere in life, but acceptance and perseverance does, atleas that's my experience.
Plenty of countries manage to conspript pretty much everyone at a certain age. Train them and let them home without having a special problem with them. Now what is the US army doing during training/stateside service?
Sorry to say, but I stand my ground. I believe it is the left % that is the root issue. As said without further explanation in my initial comment. (it's the same issue on almost every database, and I have never seen it not, being the main culprit, and the solution that never seme to fail is always index)
Assuming it only loops once in the query yes, that's 5 seconds. But (and I'm guessing here) having it in the where directly leads to something like a n+1 issue for full tablescan/non indexed queries as a right or non anchored i/like quickly leads to without the propper index.
What I'm meaning to say is that, the issue is not solved, it is simply worked around by narrowing down the set queried, not really postgres magic but usage of own data knowhow.
I believe a Trigram index whould solve the issue at its root.