Shayon Mukherjee

Bypass PostgreSQL catalog overhead with direct partition hash calculations

Is AGI paradoxical?

Pitfalls of premature closure with LLM assisted coding

Another look into PostgreSQL CTE materialization and non-idempotent subqueries

A PostgreSQL planner gotcha with CTEs DELETE and LIMIT

Selective asynchronous commits in PostgreSQL - balancing durability and performance

Challenging AI generated code from first principles

Scaling with PostgreSQL without boiling the ocean

Database mocks are just not worth it

Using CTID Based Pagination for Data Cleanups in PostgreSQL

pg_easy_replicate Supports Schema Change Tracking During Logical Replication

Stop Relying on IF NOT EXISTS for Concurrent Index Creation in PostgreSQL

The Tech Industry's Moral Vacuum

Use pg_easy_replicate for setting up Logical Replication and Switchover in PostgreSQL

Fast, Simple and Metered Concurrency in Ruby with Concurrent::Semaphore

The value of sitting on an idea

Incidents and the requirement of slowing down

Embracing the weeds

100x Faster Query in Aurora Postgres with a lower random_page_cost

Shipping Fast Requires a High Degree of Trust

Introducing pg_easy_replicate 2.0

Do you really need Foreign Keys?

pg-osc: Zero downtime schema changes in PostgreSQL

Why I enjoy PostgreSQL - Infrastructure Engineer's Perspective

To PaaS or not

talks & publications

Handling Network Failures in the Cloud

about

mitigate first, investigate later

reading list

Fetch current signal handlers without overriding in Ruby