» Tag
postgresql
65 postsPostgreSQL JSONB vs MongoDB BSON: The Real Architectural Tradeoffs
BSON and JSONB reveal deep architectural differences between MongoDB and PostgreSQL, shaping indexing, update cost, and read performance trade-offs.
PostgreSQL Row-Level Security: Where the Performance Cost Hides
Benchmarks show PostgreSQL row-level security is free with proper indexing, but unstable helper functions and membership checks can add seconds of latency.
Supabase Queues in Production: DLQs and Retries with pgmq
How to add dead-letter queues, retry limits, and poison message handling to Supabase Queues (pgmq) in production, with working SQL.
CommitBrief — AI code reviews, right in your terminal
A provider-agnostic, local-first CLI that reviews your staged changes, a historic range, or a whole GitHub pull request. Zero telemetry, no server. Free and open source.
commitbrief.comA Memory-Bounded HTML-to-PDF Architecture for Bursty Workloads
How a solo-built PDF service uses a Postgres-backed queue and streaming Chromium renders to cap memory use regardless of document size.
How Postgres-Backed Queues Scale to 30K Workflows per Second
DBOS details how SKIP LOCKED, conditional isolation levels, and partial indexes let Postgres queues scale to 30K workflows per second.
ClickHouse vs Postgres: A 100 Million Row Showdown on a Mac Mini
A Mac Mini M4 benchmark pits ClickHouse against Postgres across 100 million LLM trace rows, comparing ingest speed, disk usage, and query latency.
plx: Write PostgreSQL Stored Functions in Ruby, PHP, JS, or Python
plx transpiles Ruby, PHP, JS, and Python-like syntax into plpgsql, giving PostgreSQL developers familiar dialects with trusted, native performance.
Rewriting PostgreSQL in Rust: Challenges and Lessons Learned
Porting PostgreSQL to Rust surfaces deep challenges in memory management, concurrency, and extension compatibility, with measurable performance trade-offs.
Querying Historical Data in Postgres with the SCD Type 4 Pattern
A practical Postgres pattern using a history table, triggers, and valid_from/valid_to columns to answer point-in-time queries about record state in a single SELECT.
Huge Pages Can Enhance PostgreSQL Performance
Huge pages can optimize memory management in PostgreSQL, boosting performance.