Shayon Mukherjee
@shayonj.bsky.social
Everything, everywhere - always in progress 🏃♂️👨🏽🍳💻
"So this Diwali, a small reminder to myself, and maybe to you. Light the lamp. Not just in your home, but between people. In conversation, in community, in the spaces where it’s hardest to do so. Choose warmth over heat. Choose curiosity over certainty.."
www.shayon.dev/post/2025/30...
www.shayon.dev/post/2025/30...
Diwali
A personal reflection on Diwali. The festival of lights, the world I grew up in, and choosing light in darker times.
www.shayon.dev
October 27, 2025 at 11:02 AM
"So this Diwali, a small reminder to myself, and maybe to you. Light the lamp. Not just in your home, but between people. In conversation, in community, in the spaces where it’s hardest to do so. Choose warmth over heat. Choose curiosity over certainty.."
www.shayon.dev/post/2025/30...
www.shayon.dev/post/2025/30...
Bypass PostgreSQL catalog overhead with direct partition hash calculations
www.shayon.dev/post/2025/22...
www.shayon.dev/post/2025/22...
Bypass PostgreSQL catalog overhead with direct partition hash calculations
Eliminating PostgreSQL catalog traversal overhead with local partition calculations for up to 20x faster hash partition queries.
www.shayon.dev
August 10, 2025 at 8:37 PM
Bypass PostgreSQL catalog overhead with direct partition hash calculations
www.shayon.dev/post/2025/22...
www.shayon.dev/post/2025/22...
This is what progress looks like
July 4, 2025 at 1:07 PM
This is what progress looks like
"The paradox of artificial general intelligence might be that the more we chase it, the more we appreciate what we already have: human intelligence, in all its messy, creative, contextual glory. And perhaps...."
www.shayon.dev/post/2025/17...
www.shayon.dev/post/2025/17...
Is AGI paradoxical?
If AI learns from human intelligence, can it ever truly transcend its origins? Is AGI a technical milestone or philosophical mirage?
www.shayon.dev
June 22, 2025 at 3:18 PM
"The paradox of artificial general intelligence might be that the more we chase it, the more we appreciate what we already have: human intelligence, in all its messy, creative, contextual glory. And perhaps...."
www.shayon.dev/post/2025/17...
www.shayon.dev/post/2025/17...
Fresh off the press - some raw thoughts on "Premature Closure" in the world of AI.
www.shayon.dev/post/2025/16...
www.shayon.dev/post/2025/16...
Pitfalls of premature closure with LLM assisted coding
When LLM models generates clean, professional-looking code, it's tempting to stop exploring alternatives. But therein lies the risks that comes with premature closure. So what is premature closure?
www.shayon.dev
June 13, 2025 at 11:43 AM
Fresh off the press - some raw thoughts on "Premature Closure" in the world of AI.
www.shayon.dev/post/2025/16...
www.shayon.dev/post/2025/16...
Reposted by Shayon Mukherjee
Reposted by Shayon Mukherjee
Engineering teams know all too well how hard on-call can be. At @tineseng.bsky.social , one tool is critical to how we make it easier: Tines.
Izabela from our team shares how we do it:
www.tines.com/blog/tines-a...
Izabela from our team shares how we do it:
www.tines.com/blog/tines-a...
How our engineering team improves the on-call experience with Tines | Tines
At Tines, we have two types of on-call: daytime and out-of-hours. In this blog, we explain the daytime on-call shift, its pros and cons, and how we make it easier by using Tines.
www.tines.com
May 16, 2025 at 5:42 PM
Engineering teams know all too well how hard on-call can be. At @tineseng.bsky.social , one tool is critical to how we make it easier: Tines.
Izabela from our team shares how we do it:
www.tines.com/blog/tines-a...
Izabela from our team shares how we do it:
www.tines.com/blog/tines-a...
As much as I love shipping features, systems and performance wins just hit different! 🚀
May 15, 2025 at 9:32 PM
As much as I love shipping features, systems and performance wins just hit different! 🚀
Finding about PostgreSQL vacuums, heap truncation and standbys the hard way 🙃
github.com/postgres/pos...
github.com/postgres/pos...
github.com
May 5, 2025 at 6:26 PM
Finding about PostgreSQL vacuums, heap truncation and standbys the hard way 🙃
github.com/postgres/pos...
github.com/postgres/pos...
github.com/shayonj/pg_h...
Usually moving to partitioned tables come with a cost.
Turns out calculating which partitioned table you can send your pointed queries (without querying database) makes those queries _extremely_ fast. More to come soon.
Usually moving to partitioned tables come with a cost.
Turns out calculating which partitioned table you can send your pointed queries (without querying database) makes those queries _extremely_ fast. More to come soon.
GitHub - shayonj/pg_hash_func: Determine the target partition index for an integer key according to PostgreSQL's default hash strategy, without querying the database
Determine the target partition index for an integer key according to PostgreSQL's default hash strategy, without querying the database - shayonj/pg_hash_func
github.com
April 27, 2025 at 12:30 PM
github.com/shayonj/pg_h...
Usually moving to partitioned tables come with a cost.
Turns out calculating which partitioned table you can send your pointed queries (without querying database) makes those queries _extremely_ fast. More to come soon.
Usually moving to partitioned tables come with a cost.
Turns out calculating which partitioned table you can send your pointed queries (without querying database) makes those queries _extremely_ fast. More to come soon.
Reverse engineering PostgreSQL's hashfn.c (github.com/postgres/pos...) in Ruby to speed up point queries on partitioned tables (as one does 😂)
github.com
April 22, 2025 at 6:43 PM
Reverse engineering PostgreSQL's hashfn.c (github.com/postgres/pos...) in Ruby to speed up point queries on partitioned tables (as one does 😂)
Reposted by Shayon Mukherjee
I have some thoughts about boringtechnology.club for you, as the work turns ten years old this weekend.
Choose Boring Technology
How to be old, for young people.
boringtechnology.club
March 28, 2025 at 3:56 PM
I have some thoughts about boringtechnology.club for you, as the work turns ten years old this weekend.
Reposted by Shayon Mukherjee
Great article from @shayonj.bsky.social about async vs. sync commit in Postgres. I've talked about this with folks for year that it's not all or nothing you can toggle per session/transaction/etc. Though can't recall many folks writing it up, so thanks! www.shayon.dev/post/2025/75...
Selective asynchronous commits in PostgreSQL - balancing durability and performance
Safely leverage PostgreSQL's asynchronous commit for significant performance gains
www.shayon.dev
March 19, 2025 at 3:38 PM
Great article from @shayonj.bsky.social about async vs. sync commit in Postgres. I've talked about this with folks for year that it's not all or nothing you can toggle per session/transaction/etc. Though can't recall many folks writing it up, so thanks! www.shayon.dev/post/2025/75...
Wrote a bit about an interesting find lately www.shayon.dev/post/2025/75...
Selective asynchronous commits in PostgreSQL - balancing durability and performance
Safely leverage PostgreSQL's asynchronous commit for significant performance gains
www.shayon.dev
March 16, 2025 at 4:48 PM
Wrote a bit about an interesting find lately www.shayon.dev/post/2025/75...
Are folks running PostgreSQL DBs with synchronous_commit on or off? 🌶️
March 9, 2025 at 1:25 PM
Are folks running PostgreSQL DBs with synchronous_commit on or off? 🌶️
"While these tools boost productivity, they’re not a replacement for critical thinking. Taking the time to understand why something works (or breaks) and building strong mental models isn’t just busy work..."
www.shayon.dev/post/2025/53...
www.shayon.dev/post/2025/53...
Challenging AI generated code from first principles
While these tools boost productivity, they're not a replacement for critical thinking. Taking the time to understand why something works (or breaks) and building strong mental models isn't just busy w...
www.shayon.dev
February 22, 2025 at 10:26 PM
"While these tools boost productivity, they’re not a replacement for critical thinking. Taking the time to understand why something works (or breaks) and building strong mental models isn’t just busy work..."
www.shayon.dev/post/2025/53...
www.shayon.dev/post/2025/53...
Some more ramblings from working on PostgreSQL
(Had its brief moment on HN)
www.shayon.dev/post/2025/40...
(Had its brief moment on HN)
www.shayon.dev/post/2025/40...
Scaling with PostgreSQL without boiling the ocean
Practical scaling strategies for application developers who don't have a dedicated database team
www.shayon.dev
February 9, 2025 at 5:24 PM
Some more ramblings from working on PostgreSQL
(Had its brief moment on HN)
www.shayon.dev/post/2025/40...
(Had its brief moment on HN)
www.shayon.dev/post/2025/40...
Counting is a hard problem.
December 6, 2024 at 6:43 PM
Counting is a hard problem.
Planning a wedding with your parents is a group project that no one prepared you for.
November 25, 2024 at 11:36 PM
Planning a wedding with your parents is a group project that no one prepared you for.
Post run, half baked thought:
In memory store, flush to S3 every N interval. Reader replicas straight from S3 (?) New S3 primitives (conditional writes, and append only) for strong consistency and other good semantics.
Costs ? Unknown 💸
In memory store, flush to S3 every N interval. Reader replicas straight from S3 (?) New S3 primitives (conditional writes, and append only) for strong consistency and other good semantics.
Costs ? Unknown 💸
November 24, 2024 at 7:58 PM
Post run, half baked thought:
In memory store, flush to S3 every N interval. Reader replicas straight from S3 (?) New S3 primitives (conditional writes, and append only) for strong consistency and other good semantics.
Costs ? Unknown 💸
In memory store, flush to S3 every N interval. Reader replicas straight from S3 (?) New S3 primitives (conditional writes, and append only) for strong consistency and other good semantics.
Costs ? Unknown 💸
Rollercoaster of emotions next few days.
November 19, 2024 at 11:51 AM
Rollercoaster of emotions next few days.