Tag: indexes

Episode 454: Thomas Richter on Postgres as an OLAP database

Filed in Episodes by on April 9, 2021 0 Comments
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. Related Links Swarm64 Postgres homepage A quick explanation of OLAP and OLTP Postgres […]

Continue Reading »

SE-Radio Episode 362: Simon Riggs on Advanced Features of PostgreSQL

Filed in Episodes by on April 10, 2019 0 Comments
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 […]

Continue Reading »