For funsies www.shayon.dev/post/2025/27...

⚖️

Bypass PostgreSQL catalog overhead with direct partition hash calculations www.shayon.dev/post/2025/22...

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...

Good morning HN!

Fresh off the press - some raw thoughts on "Premature Closure" in the world of AI. www.shayon.dev/post/2025/16...

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...

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...

This was a fun one www.shayon.dev/post/2025/11...

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.

Reverse engineering PostgreSQL's hashfn.c (github.com/postgres/pos...) in Ruby to speed up point queries on partitioned tables (as one does 😂)

I have some thoughts about boringtechnology.club for you, as the work turns ten years old this weekend.

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...

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...

Some more ramblings from working on PostgreSQL (Had its brief moment on HN) www.shayon.dev/post/2025/40...

Counting is a hard problem.

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 💸

Rollercoaster of emotions next few days.

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...

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

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...

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

Reminder: SQLite is 35% faster than the filesystem while also using 20% less disk space read more here: www.sqlite.org/faste...

Noodling on a tool to sync (CDC)between Postgres DBs. Define rules to anonymize, filter, or transform data before it reaches the destination. Considering a cloud version as well to keep it zero-touch-ops. Just setup & go. Early days, open to feedback. Design is flexible github.com/shayonj/pg_flo

Not a yolo day, today.

Ok so turns out this is possible! There's a Chrome extension called Sky Follower Bridge that does the matching for you. This worked with zero drama.

Giving this starter pack thing a try, if you want a little Postgres in your feed (and who doesn't) here's some folks work a follow - go.bsky.app/Acp7hmk