Arpit Bhayani
Projects
Blogs
Notes
Videos
Papershelf
Bookshelf
Courses
Talks
Home
Topics
Postgresql
#postgresql
(13)
4 notes
•
9 videos
All
13
Distributed Systems
6
Databases
3
Systems Internals
3
Software Engineering
1
2026
(5)
Sep 09
NOTE
PostgreSQL 19 Ships Property Graphs Enabling Direct Query of Existing Tables
Software Engineering
#software-engineering
#postgresql
#property-graphs
Jun 23
NOTE
PostgreSQL Uses Histograms and MCVs to Estimate Rows
Distributed Systems
#distributed-systems
#databases
#histograms
Apr 29
NOTE
Pushdown optimization in pg_clickhouse improves data querying efficiency
Distributed Systems
#distributed-systems
#clickhouse
#data-filtering
Apr 14
NOTE
Update Heavy PostgreSQL Workloads Require Autovacuum Tuning
Distributed Systems
#distributed-systems
#autovacuum
#concurrency
Jan 23
VIDEO
How OpenAI Scales PostgreSQL to Power 800 Million ChatGPT Users
Databases
#postgresql
#database-scaling
#distributed-systems
2025
(1)
Feb 02
VIDEO
How Bitbucket Achieved Read-After-Write Consistency and Reduced Master Database Load by 50%
Distributed Systems
#read-after-write-consistency
#database-scaling
#postgresql
2024
(5)
May 10
VIDEO
Designing Reddit's Unified Media Metadata Store: 100k RPS at 17ms p99 Latency
Distributed Systems
#postgresql
#aurora
#pgbouncer
May 04
VIDEO
How PostgreSQL Generates All Query Execution Plans
Systems Internals
#postgresql
#query-optimization
#query-planner
Apr 19
VIDEO
How PostgreSQL Parses Queries and Constructs the Parse Tree
Systems Internals
#postgresql
#databases
#systems-internals
Apr 12
VIDEO
PostgreSQL Connection Management: The Process-per-Client Model Deep Dive
Systems Internals
#postgresql
#systems-internals
#operating-systems
Jan 30
VIDEO
Choosing the Right String Column Data Type: CHAR vs VARCHAR vs TEXT
Databases
#databases
#postgresql
#mysql
2023
(1)
Oct 13
VIDEO
Migrating from Cloud to Bare Metal: Dukaan's Architecture and Infrastructure Blueprint
Distributed Systems
#bare-metal
#cloud-migration
#kubernetes
2022
(1)
Sep 19
VIDEO
How Instagram Efficiently Serves Hashtags Ordered by Count
Databases
#postgresql
#indexing
#partial-indexes