Tag: #postgresql
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 60 posts
A Deep Dive into PostgreSQL Architecture — From MVCC to Vectors
A deep look at the internal architecture of PostgreSQL, from process and memory structure to MVCC, indexes, query execution, replication, partitioning, and extensions like pgvector. We unpack the core mechanisms with ASC
2026-06-27 · 11 min read #postgresql#database#mvcc#architecture#indexingPostgreSQL Version Upgrade Strategies — pg_upgrade and Logical Replication
A practical comparison of three ways to perform a PostgreSQL major version upgrade: dump/restore, pgupgrade, and logical replication. We cover downtime trade-offs, the pgupgrade --link procedure and its caveats, near-zer
2026-06-16 · 16 min read #postgresql#database#upgrade#pg-upgrade#logical-replicationAWS DMS in Practice — Migration and Continuous Replication (CDC)
A practitioner walkthrough of AWS Database Migration Service from its building blocks to full load and CDC, heterogeneous migration with SCT, LOB handling and data validation, monitoring and cut-over strategy. It also co
2026-06-16 · 19 min read #aws#dms#database#migration#cdcOnline Schema Changes on Large Tables — gh-ost, pt-online-schema-change, and Native Online DDL
Run an ALTER against a table with hundreds of millions of rows and your service can grind to a halt. This post walks through the limits of MySQL native Online DDL, how trigger-based pt-online-schema-change and binlog-bas
2026-06-16 · 21 min read #database#mysql#postgresql#migration#gh-ostCross-Engine Database Migration — From Oracle to PostgreSQL (and Beyond)
We unpack cross-engine database migration from Oracle to PostgreSQL, starting with the real motivations of licensing and cloud. The post covers the differences between PL/SQL and PL/pgSQL, compatibility gaps in data type
2026-06-16 · 19 min read #postgresql#oracle#database#migration#ora2pgModern PostgreSQL 2026 — Postgres 17 / 18 / pgvector / pgvectorscale / pgai / TimescaleDB / PostGIS / Citus Deep Dive
A snapshot of the PostgreSQL ecosystem as of May 2026. Covers Postgres 17 (Sept 2024) incremental backup, JSONTABLE, and MERGE improvements, Postgres 18 (Sept 2025) virtual generated columns and OAuth2, the vector extens
2026-05-16 · 24 min read #postgresql#postgres-17#postgres-18#pgvector#pgvectorscaleDatabase Engines 2026 Deep-Dive — Postgres Won the API, ClickHouse and DuckDB Won Analytics
PostgreSQL 17/18, MySQL 9, MariaDB 12, SQLite + libSQL + Turso, DuckDB 1.x, ClickHouse, StarRocks, Doris, Druid, Pinot, TiDB, CockroachDB 25, YugabyteDB, Cassandra 5, ScyllaDB, Aerospike, Neon, Supabase, PlanetScale, Xat
2026-05-16 · 17 min read #database#postgresql#mysql#clickhouse#duckdbDistributed SQL / NewSQL 2026 — CockroachDB / TiDB / YugabyteDB / Spanner / Aurora DSQL / Neon Deep Dive
The 2026 distributed SQL landscape no longer fits under the single word "NewSQL" that defined the early 2020s. CockroachDB 24 has settled into its position eighteen months after its license change, TiDB 8 has dragged the
2026-05-15 · 18 min read #database#distributed-sql#newsql#cockroachdb#tidbTypeScript ORMs and Query Builders 2026 — Drizzle vs Kysely vs Prisma vs postgres.js Deep Dive (How Close to SQL?) (english)
In 2026, TypeScript database access is no longer a 'Prisma or raw SQL' binary. Drizzle has claimed the headless-ORM seat with the closest-to-SQL ergonomics, Kysely has won over raw-SQL teams as a schemaless type-safe que
2026-05-14 · 20 min read #typescript#orm#drizzle#kysely#prismaPostgreSQL Production Operations Complete Guide 2025: Extensions, Tuning, Monitoring, HA
Everything about running PostgreSQL in production! Essential extensions (pgstatstatements/pgvector/PostGIS/TimescaleDB), performance tuning (sharedbuffers/workmem/effectivecachesize), VACUUM/Autovacuum management, monito
2026-04-15 · 7 min read #postgresql#database#production#extensions#performancePostgreSQL Internals Deep Dive — MVCC, VACUUM, WAL, Query Planner, Index, Partitioning, pgvector (2025)
Why did PostgreSQL become "the second most powerful DB after Oracle"? MVCC tuple versioning and the VACUUM burden, WAL and streaming replication, how the Query Planner builds execution plans, choosing among B-Tree/GIN/BR
2026-04-15 · 14 min read #postgresql#database#mvcc#query-optimization#infraDistributed Databases 2025 — CockroachDB, Spanner, TiDB, Yugabyte, Aurora DSQL, Neon, PlanetScale, Turso, D1 (S7 E3)
The "just use one database" era is over. In 2024–2025 distributed SQL (CockroachDB, Spanner, TiDB, Yugabyte), serverless Postgres (Neon, Supabase, PlanetScale, Aurora DSQL), and edge SQLite (Turso/libSQL, Cloudflare D1)
2026-04-15 · 11 min read #database#distributed-sql#postgresql#cockroachdb#spannerDB Index Master Guide 2025: B-Tree, Hash, GIN, BRIN, Composite Indexes, Query Plan Analysis
Everything about DB indexes. B-Tree internals, comparison of Hash/GIN/GiST/BRIN, composite index design, covering/partial/expression indexes, reading EXPLAIN ANALYZE, 10 reasons an index is skipped, real-world tuning cas
2026-04-15 · 10 min read #database#indexing#btree#hash#ginDatabase Query Optimizer Complete Guide 2025: Volcano, Cascades, Cost-Based, Cardinality Estimation — PostgreSQL/MySQL In-Depth Analysis
A single SQL statement can turn into hundreds of different execution plans. From Volcano to Cascades, how cost-based optimizers work, the pitfalls of cardinality estimation, and the internals of PostgreSQL and MySQL — a
2026-04-15 · 24 min read #database#query-optimizer#volcano#cascades#cost-basedDatabase MVCC & Isolation Levels Complete Guide 2025: Read Phenomena, Snapshot Isolation, SSI, PostgreSQL/InnoDB Internals
From Dirty Read to Write Skew, from Read Committed to Serializable Snapshot Isolation. A 720-line deep dive into the real behavior of each isolation level and the MVCC internals of PostgreSQL and InnoDB.
2026-04-15 · 19 min read #database#mvcc#isolation-level#snapshot-isolation#serializableDatabase Complete Guide — Internals, Indexes, Query Planner, Partitioning, Vector DB (Season 2 Ep 13, 2025)
Treat a database as nothing but "the place where SQL goes" and you stay junior forever. The internals of B-Tree, LSM-Tree, and Hash Index; how the query planner turns a query into an execution plan; the four transaction
2026-04-15 · 14 min read #database#postgresql#b-tree#lsm-tree#indexingCDC (Change Data Capture) Complete Guide 2025: Debezium, Kafka, Data Sync, Outbox Pattern
Everything about CDC — how it works (WAL/binlog based), Debezium architecture, PostgreSQL Logical Replication, MySQL binlog, Outbox Pattern, data warehouse sync, Kafka integration, migration, common pitfalls.
2026-04-15 · 11 min read #cdc#debezium#kafka#postgresql#mysqlKubernetes Database Deep Dive 2025: Operator Patterns, HA Configuration, Backup/Recovery, Performance Tuning
K8s DB operations deep dive! CloudNativePG vs Percona Operator comparison, Primary-Replica automatic Failover, pgBackRest/Velero backup, WAL archiving, Connection Pooling (PgBouncer), resource tuning (CPU/Memory/IOPS), A
2026-04-13 · 20 min read #kubernetes#database#operator#cloudnativepg#perconaThe Complete Guide to Database Fundamentals — SQL, Normalization, Indexes, Transactions, NoSQL
Everything about databases from SQL basics to normalization, index internals (B-Tree), transactions (ACID), NoSQL selection criteria, and query optimization.
2026-04-12 · 17 min read #database#sql#nosql#postgresql#mongodbRunning Databases on K8s -- Complete Guide to CNPG, Percona, Vitess, and Helm Charts
A comprehensive overview of running databases in Kubernetes environments. We compare CloudNativePG, Percona Operator, Vitess, and major Helm charts, and share practical operational know-how.
2026-04-11 · 15 min read #database#kubernetes#cnpg#postgresql#mysql