Now that you mention it, I guess I've experienced *similar* issues (more to do with joins, unions, materializations, windows, etc) even when there is a query planner.
Even though the query planner has an optimizer, the plan produced isn't optimal. In some cases I have had to play around with the SQL (resulting in less than ideal SQL) to get the optimizer to do what it should.
This demonstrates the exact point you made:
> The advantage is predictability of execution
In my example, while I ultimately overcame the issues with the sub-optimal plan, there's no assurances about what the query planner/optimizer will come up with tomorrow.
I'm interested to understand why you think it should differ between OLAP and OLTP?
Are you suggesting that columns closer to the top matters for OLAP bc OLAP is columnar? Ultimately, a query planner is going to figure out what happens first, so I can't imagine your point has anything to do with execution.
Lots of things to move from multiple (mental) "I'll deal with it later" piles to here, so excuse the randomness...
I was diagnosed with ADHD at 44/45 too. I can't believe that no one (not even me) identified it based on all the symptoms and signs throughout my life. Medication was a life-changer. Suddenly all of my therapy started to become more effective. I was able to slow things down and actually take a long, hard look inside. Gave me the ability listen, understand and validate my emotions, fears, concerns, behavior... instead of just reacting or pushing things down and out of the way. One important realization was that the medication wasn't just for work hours. It also enabled me to be "present" outside of work too.
Just wondering if anyone has an opinion on Andrew Huberman. I'm always skeptical about anyone on social media these days. Doesn't seem like he's trying to sell us anything, and has seemingly decent, understandable explanations about brain bio-chemistry and characteristics of those with ADHD.
Can anyone recommend a tool for the phone that can use Siri/etc to record and organize reminders, thoughts, etc? Imagine the functionality Loom (mentioned in the link), Obsidian, todoist, etc... all mixed into one app, but Voice/Siri interaction being the main interface to interact with? I find that when I use a visual UI, I end up doing something unrelated. Tweaking settings, noticing a txt I haven't responded to, trying to organize previous tasks, etc...
I was one of those stay-up-to-the-late-hours type of person all throughout my life. That of course changed with a family, and so I began to suffer as a result. I found that I had no time to focus on learning and keeping my skills up to date. It made me really frustrated, fearful and resentful. Especially difficult bc I never really "worked", I was passionate about what I do and love it. At some point I figured out a way to use that anxiety to get me out of bed early in the morning (quite unusual and difficult for those with ADHD) and to my desk hours before anyone could disturb me. Suddenly I was getting up at 4-5am (6-7hrs of sleep), ready, refreshed and at my desk, giving me several hours before anyone could interrupt me. That all changed recently due to some personal matters, but I think I'm on the right path to getting back there.
Anyone else heard that those with ADHD often think/write like a lisp language? Lots of "...", deeply nested "((()))", "etc"... in their sentences.
I see every sign of ADHD in my young daughter. I guess I'm glad that I have and can recognize it so that at least I can empathize/sympathize/understand/validate what she will go through in life, and hopefully be able to provide some guidance/help/support for her as she navigates the difficulties. I wish I had had that throughout my life, and in many ways, on a daily basis, I feel like I'm learning everything from scratch with my recent discovery. I now see everything through a different lens, like I needed glasses all my life and only recently received glasses.
To anyone that just bought a new/newish house with only RJ-11/phone outlets installed...
Pull off the face plate and check to see what kind of wire they used. Chances are that it is cat-5/6/7/8 and you MIGHT be able to use it as an ethernet outlet if it was installed appropriately.
This was done in a former property of mine and I went through the place and replaced certain RJ-11 outlets with RJ-45 ones.
:( Sorry to hear that... I know it must be so incredibly frustrating!
Sounds like it isn't an issue of flip/flopping between discrete and integrated GPU then... must just be the integrated GPU and its ability to deal with non-native resolutions.
It's unclear to me if these issues are happening when you are running the iOS app on your Mac (emulating during development)?
If so, try setting Mac to use the discrete GPU all the time and see if it keeps happening. MacOS flip/flopping between discrete and integrated GPU was an issue for me. I can only imagine what MacOS might be doing during development of a graphics app such as yours.
a little unclear if you don't have a hub, or do have an Anker hub, but try moving the Anker hub far away from your Macbook and see if you still have the bluetooth issue. You need a USB cable (depending on what's the hub is you might need a 3.1 Gen2) long enough.
For me it was a hardware proximity issue. Powered external devices interfering with the Mac's bluetooth.
This whole thread is striking a nerve with me since these seem to be all of the issues i had been dealing with since getting a new 16 inch a few weeks back. Specifically "windowserver" and also these bluetooth issues.
See my other comment in this thread about how i solved "windowserver".
Bluetooth issue was a hw proximity issue for me. My CalDigit hub was mounted right below my Macbook. I noticed when I moved my MacBook's location (still connected to hub), the bluetooth issue when away.
It's worth a try if you have a powered accessory near your macbook and haven't tried this already, but...
I do still get the issue once in a while, but I can now at least just turn the keyboard/touchpad off/on and it goes back to normal whereas before, it happened all the time.
Once in a while I still have to Shift+Option+"bluetooth menu icon" and reset bluetooth module.
I know these are just work arounds, but at least it allows me to get back to work and only have to deal with it weekly instead of not being able to use bluetooth at all.
Edit: just upgraded to 12.0.1 and noticed Shift+Option+"bluetooth menu icon" to reset bluetooth module is gone!?
I think I had the same problem as you (similar hw and setup). Do you have a discrete GPU? If so check the link below out. For me, this behavior was due to OSX flip-flopping between discrete and internal GPU. Once I set it to discrete all the time (I'm always plugged in) the problem went away.
Seems to me a different issue than what people are complaining about atm... but what do i know, might be one and the same.
Edit: very weird... Looks like this setting was reverted for me. I just updated from 11.? to 12.0.1, so I wonder if the installer undid some of my changes. No performance issues, but I've literally just my computer on for the first time after the upgrade.
401k limits are about $58k per year... You can only personally contribute up to about $20k per year. There are ways to take advantage of the difference such as employer matching and after-tax traditional 401ks (and instantly convert to Roth money).
This is also a way of contributing to a Roth (IRA?) if you don't qualify for a regular Roth IRA (make too much money) or want to contribute more than the $6k limit per year.
Makes perfect sense. Poaching FB's (or any competition for that matter) employees potentially makes them easier to compete with and increases the cost for FB to compete.
Even though the query planner has an optimizer, the plan produced isn't optimal. In some cases I have had to play around with the SQL (resulting in less than ideal SQL) to get the optimizer to do what it should.
This demonstrates the exact point you made:
> The advantage is predictability of execution
In my example, while I ultimately overcame the issues with the sub-optimal plan, there's no assurances about what the query planner/optimizer will come up with tomorrow.