Profile avatar
igupta.in
Senior Backend and Infrastructure engineer. I will absolutely automate anything and everything. Building spot.rackspace.com. Polishing my systems programming with Zig. ⚡️ I blog about tech and human behaviour at igupta.in recurse.com alumni. He/Him.
263 posts 1,137 followers 225 following
Regular Contributor
Active Commenter
comment in response to post
I felt the same until I read that tabs are more accessible.
comment in response to post
1️⃣ Stale stats: ANALYZE hasn’t run; filter looks un-selective. 2️⃣ Truly un-selective: Stats are right; scan really is cheaper. 3️⃣ Complex estimates: Many joins / ORs / CTE / functions scramble row estimates. 4️⃣ Handcuffs on: RLS limits optimizations or GUCs forbid the path. 5️⃣ Planner bugs: Rare but...
comment in response to post
Fenix 8 is on a sale right now. 😛
comment in response to post
First part of action item done!
comment in response to post
I don't think AI is good or bad, but it will definitely be used for good and bad things. Gas lamps replaced whale oil lamps. Electric lights replaced gas lamps. A hammer, a gun, and a garden can all be tools for thriving or malice. In capitalism, AI will cause as much harm as people tolerate.
comment in response to post
I want to avoid my own process management. And in Go this can get quite terse very easily. I could do this in bash, but I think long term it gets harder to maintain as our codebase evolves.
comment in response to post
I just moved here last month! The city has a vibe! And I love it!
comment in response to post
It’s an underrated perk.
comment in response to post
I didn’t coin the term, but I call it the Pac-Man rule. Always stand in the Pac-Man shape so there’s space for at least one person to join. Rinse and repeat.
comment in response to post
Too bad they don’t support a .in domain yet. 😢
comment in response to post
Even the M1 is quite good for everyday dev stuff including some heavy lifting. Unless you’re doing some serious AV processing or LLMs locally, M1 itself is good enough if you can find a refurbished one! M1 Max is my daily driver. Maxed out the RAM at 64GB (newer models support 96GB! 😲 )
comment in response to post
Sorry I missed that too. Rectified in my 2nd reply here: bsky.app/profile/igup...
comment in response to post
The hardware is legit good. The M series don’t get hot even under load. And if they do at all, tweaking the fan speed with something like “stats” (an OSX app) will bring it down immediately. Almost never hear the fan unless I boost it up myself!
comment in response to post
Also it doesn’t slow down over years of usage unlike windows. Also some pretty nice productivity apps which helped me with the transition from arch to Mac for both work and personal stuff. It’s nice to not have to worry about graphics drivers anymore either.
comment in response to post
Sorry to hear that. Take care of yourself. Things will turn around soon!
comment in response to post
Good luck! 🚀
comment in response to post
What about your neighborhood makes it a heli magnet? 😄
comment in response to post
Careful or they’ll adopt you! 😛
comment in response to post
Couple of nice features in this release! Haven’t had a chance to upgrade our work project to 1.24 yet unfortunately.
comment in response to post
Anyway, as an interviwer your job is not just to assess the candidate's skills. It is also to help them relax so that they can show their best version to you under stressful circumstances.
comment in response to post
I remember once answsering stupidtly to a trick question and still can't reconcile with how I ended up blurting up something totally senseless that continues to be embarrasing years later. The fact that it was a trick question wasn't even apparent until later when I replayed my interview.
comment in response to post
As a candidate, there's nothing worse than trick questions when your heart is beating at 180bpm and you're second guessing everything including your own name! And trick questions certainly don't help at all with the situation.
comment in response to post
Left a couple of small comments. I think I spot an unreachable code section in one of the functions. But overall your code is clean and very Pythonic! 👌
comment in response to post
Two sides to this: 1. Mistakes happen all the time. If the talk abstract is promising I’d reach out to the submitter for the full title. 2. The talk title is too long that it didn’t fit in the character limit (assuming long enough character limit) is a sign of it not being to the point.
comment in response to post
Blog post?