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...
Diwali
A personal reflection on Diwali. The festival of lights, the world I grew up in, and choosing light in darker times.
shayon.dev
Bypass PostgreSQL catalog overhead with direct partition hash calculations 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.
shayon.dev
"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...
Is AGI paradoxical?
If AI learns from human intelligence, can it ever truly transcend its origins? Is AGI a technical milestone or philosophical mirage?
shayon.dev
Fresh off the press - some raw thoughts on "Premature Closure" in the world of AI. 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?
shayon.dev
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...
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.
tines.com
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
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.
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
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
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
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
shayon.dev
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...
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...
shayon.dev
Some more ramblings from working on PostgreSQL (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
shayon.dev
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 💸
Very heartwarming to see other companies finding pg_easy_replicate (born out of @TinesEng) useful for large scale PostgreSQL migrations 🫶🏽 github.com/shayonj/pg_e...
Cross Cloud Migration Validated · Issue #187 · shayonj/pg_easy_replicate
Just wanted to put this out there - cross cloud migration is validated. It is definitely possible to migrate from AWS >> Azure or vice versa, the only minor preparation step is that you need to ens...
github.com
Just realized with pg_flo you can use the same DB as both source & destination. This lets you create shadow tables & remap data flows within a single DB using the routing feature. Useful for data migrations when you need time to verify data integrity! www.pgflo.io
pg_flo - Stream, transform, and route PostgreSQL data in real-time
pg_flo is a powerful PostgreSQL data replication tool that enables real-time streaming, table routing, data transformation, and secure data masking between databases.
pgflo.io
Happy to see pg_flo in top 5 on Hacker News today. Looks like all positive feedback. Excited to continue hacking on it.
Wrote a few words about using #PostgreSQL page location (CTID) for large data cleanups as a workaround www.shayon.dev/post/2024/30...
Using CTID Based Pagination for Data Cleanups in PostgreSQL
When dealing with very large PostgreSQL tables (we're talking 15TB+), sometimes routine maintenance like archiving very old data can become surprisingly challenging
shayon.dev
Just shipped the v1 of new table routing feature in pg_flo. This way you can easily route PostgreSQL changes to different tables & column names in the target database. Lots more soon. In the mean time, a small and simple site: www.pgflo.io
pg_flo - Stream, transform, and route PostgreSQL data in real-time
pg_flo is a powerful PostgreSQL data replication tool that enables real-time streaming, table routing, data transformation, and secure data masking between databases.
pgflo.io
