PGConf NYC 2021 Conference
Recently I had the opportunity to travel to NYC to present at PGConf NYC 2021.
Prioritizing Work that Matters
In the StaffEng book, there is a section called Work on What Matters.
Find Duplicate Records Using ROW_NUMBER Window Function
Duplicate rows can happen when a database unique constraint is missing. Once found, finding and deleting duplicates in a fast way is necessary before the constraint can be added.
Bulk Inserts, RETURNING, and UNLOGGED Tables
By using UNLOGGED tables, we can insert rows at a higher rate when compared with a logged table (the default). But there’s a trade-off.
Using pg_repack to Rebuild Indexes
Over time our indexes became bloated, meaning invisible rows were still present in the index. This is inefficient and can be addressed by rebuilding the index.
Manually Fixing a Rails Migration
This tip is a recipe for how to recover from a Rails migration that failed to apply in production. This process could work for any SQL migration. The example below is for an index added to a table.
PostgreSQL pgbench Workload Simulation
We operate a high scale API application that relies on a single primary PostgreSQL instance. We have scaled up the DB instance vertically, acquiring more CPU, Memory, and disk IO over time.
PostgreSQL Indexes: Prune and Tune
Indexes are data structures designed for fast retrieval. For databases with high row counts, Indexes that match queries well are critical to achieving good performance.
JWT, JWK, and JWKS Oh My
Authentication and authorization with JSON technologies can be a confusing mess of acronyms, so this post is an attempt to sort these out. This post including the title, is very similar to Red Thunder: JWTs? JWKs? ‘kid’s? ‘x5t’s? Oh my!....
Throttling and Temporary Bans with Rack Attack
Rack Attack is a Rack middleware developed at Kickstarter that can be used to throttle endpoints and temporarily ban bad actors.