


cooking something crazy
Parth Agrawal
2.7K posts

@shankstwin
rust freak | One piece addict 💀 | NIT NGP CS'28



cooking something crazy









Since 1 week I am deep diving Postgres Here's what I covered : - MVCC — how Postgres avoids read locks - WAL — Write-Ahead Log, crash recovery, checkpoint - VACUUM and autovacuum — dead tuple cleanup - Connection pooling with PgBouncer — pool modes - Row-level security — tenant isolation at DB layer - Logical & streaming replication - Partitioning — range, list, hash, partition pruning - Full-text search — tsvector, tsquery, GIN indexes - JSONB with GIN index — flexible dynamic data - Window functions — ROW_NUMBER, LAG, LEAD, PARTITION BY - CTEs - common table expressions, recursive CTEs for trees - B-Tree — node structure, split/merge, height, range scans - Hash index — O(1) equality, not suitable for range - GiST — generalized search tree, geometric/range types - BRIN — block range, massive naturally-ordered tables - Partial indexes — WHERE clause, smaller, faster updates - Expression indexes — index on function result - Covering indexes — INCLUDE clause, index-only scans - EXPLAIN ANALYZE — reading query plans, actual vs estimated - N+1 query problem — identifying and fixing with JOIN Still learning covering more things I am really enjoying how things work and revising old concepts Will keep updating this list




