Stories by shayonj

Shipping Fast Requires a High Degree of Trust

Faster PostgreSQL partition look ups with client-side integer hashing in Ruby

Another look into PostgreSQL CTE materialization and non-idempotent subqueries

A PostgreSQL Planner Gotcha with CTEs Delete and Limit

pg_hash_func Ruby gem: Calculate PostgreSQL partition index without querying

Selective async commits in PostgreSQL – balancing durability and performance

Selective async commits in PostgreSQL – balancing durability and performance

Challenging AI generated code from first principles

Challenging AI generated code from first principles

Database mocks are not worth it

pg_flo – Stream, transform, and re-route PostgreSQL data in real-time

Stream, transform, and route PostgreSQL data in real-time

Using PostgreSQL Page-Based (CTID) Pagination for Data Cleanups

Stream, transform, and route PostgreSQL data in real-time (early build)

Pg_flo – Easily move and transform data between PostgreSQL databases

Shrinking Big PostgreSQL Tables with the Copy-Swap-Drop Technique

A simple tool to observe PostgreSQL database locks in Rails apps

Beyond logical replication: pg_easy_replicate Supports Tracking DDL Changes

Don't rely on IF NOT EXISTS for concurrent index creation in PostgreSQL

1