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