PostGIS

Nik and Michael are joined by Regina Obe and Paul Ramsey to discuss PostGIS. Here are some links to things they mentioned: Regina Obe https://postgres.fm/people/regina-obe Paul Ramsey https://postgres.fm/people/paul-ramsey PostGIS https://postgis.net MobilityDB https://github.com/MobilityDB/MobilityDB pgRouting https://github.com/pgRouting/pgrouting Google BigQuery GIS public alpha blog post https://cloud.google.com/blog/products/data-analytics/whats-happening-bigquery-integrated-machine-learning-maps-and-more PostGIS Day 2025 talk recordings https://www.youtube.com/watch?v=wuNO_cW2g-0&list=PLavJpcg8cl1EkQWoCbczsOjFTe-SHg_8m pg_lake https://github.com/Snowflake-Labs/pg_lake GeoParquet https://geoparquet.org ST_DWithin https://postgis.net/docs/ST_DWithin.html Postgres JSONB Columns and TOAST: A Performance Guide https://www.snowflake.com/en/engineering-blog/postgres-jsonb-columns-and-toast FOSS4G https://foss4g.org OpenStreetMap https://www.openstreetmap.org PgDay Boston https://2026.pgdayboston.org SKILL.md file https://github.com/postgis/postgis/blob/68dde711039986b47eb62feda45bb24b13b0ea37/doc/SKILL.md Production query plans without production data (blog post by Radim Marek) https://boringsql.com/posts/portable-stats PostgreSQL: Up and Running, 4th Edition (by Regina Obe, Leo Hsu) https://www.oreilly.com/library/view/postgresql-up-and/9798341660885 ~~~ What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc! ~~~ Postgres FM is produced by: Michael Christofides, founder of pgMustard Nikolay Samokhvalov, founder of Postgres.ai With credit to: Jessie Draws for the elephant artwork