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 calculate aggregates on subsets of data; common table expressions to write performant graph queries within Postgres; user defined data types and user defined functions to support GIS, full text and time series data; foreign Data Wrappers to access data from other datastores such as MySQL, Mongo; block range indexes, generalized indexes, nearest-neighbor indexes; replication and high availability, hot stand-by nodes; zero downtime upgrades using logical replication; ease of use: robustness, accuracy, trust; securing data with encryption and authentication; levels of transaction isolation
Show Notes
Related Links
- https://www.postgresql.org/
- https://postgresconf.org/
- https://www.postgresql.org/about/featurematrix/
- https://www.2ndquadrant.com/en/postgresql/postgresql-story/
- http://www.craigkerstiens.com/2018/01/31/postgres-hidden-gems/
- http://www.se-radio.net/2012/04/episode-185-dwight-merriman-on-replication/
- http://www.se-radio.net/2018/06/se-radio-episode-328-bruce-momjian-on-the-postgres-query-planner/
