#postgresql

7 pages search “postgresql” ↳ all tags

Wiki 5

Linux 7.0 cuts PostgreSQL throughput in half Removing PREEMPT_NONE in Linux 7.0 lets the scheduler preempt processes mid-page-fault while holding a PostgreSQL spinlock, melting CPU on contended workloads
Linux Kernel in PostgreSQL via pgit 1.4M kernel commits in PostgreSQL via pgit; contributor bottlenecks, GPU driver churn, SQL-queryable git
Postgres LISTEN/NOTIFY Can Actually Scale How DBOS took Postgres LISTEN/NOTIFY from 2.9K to 60K writes/sec by batching notifications
PostgreSQL Open-source relational database; process-per-connection model with a shared buffer pool, central to several recent kernel-interaction stories
Things You Didn't Know About Indexes Common index pitfalls (composite order, functions) and lesser-known types (partial, covering, functional)

pgit Imports git repository history into PostgreSQL so commits and file versions are queryable in SQL
PGSimCity Browser 3D city where PostgreSQL's buffer pool, WAL, checkpointer and vacuum are walkable buildings