Tag: indexes
Episode 485: Howard Chu on B+tree Data Structure in Depth
Howard Chu, CTO of Symas Corp and chief architect of the OpenLDAP project, discusses the key features of B+tree data structures, which are the default selection for efficient and predictable storage of sorted data. Host Gavin Henry spoke with Chu about B+tree data structures; why they allow searches, insertions, and deletions in logarithmic time; what […]
Episode 454: Thomas Richter on Postgres as an OLAP database
Thomas Richter, founder of Swarm64, discusses the internals of the Postgres open source database project. Host Adam Conrad spoke with Richter about an introduction to relational databases, comparisons of OLAP and OLTP structures, performance considerations, and advanced features of the Postgres architecture. This episode sponsored by O’Reilly. Related Links Swarm64 Postgres homepage A quick explanation […]
SE-Radio Episode 362: Simon Riggs on Advanced Features of PostgreSQL
Simon Riggs, founder and CTO of 2nd Quadrant, discusses the advanced features of the Postgres database, that allow developers to focus on applications whilst the database does the heavy lifting of handling large and diverse quantities of data. Host Simon Crossley spoke with Riggs about advanced SQL, indexes, extensibility and scale; using window functions to […]
SE Radio Alerts
