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 postgres.fm/people/regina-obe
• Paul Ramsey postgres.fm/people/paul-ramsey
• PostGIS postgis.net
• MobilityDB github.com/MobilityDB/MobilityDB
• pgRouting github.com/pgRouting/pgrouting
• Google BigQuery GIS public alpha blog post cloud.google.com/blog/products/data-analytics/…
• PostGIS Day 2025 talk recordings youtube.com/watch?v=wuNO_cW2g-0&list=PLavJ…
• pg_lake github.com/Snowflake-Labs/pg_lake
• GeoParquet geoparquet.org
• ST_DWithin postgis.net/docs/ST_DWithin.html
• Postgres JSONB Columns and TOAST: A Performance Guide snowflake.com/en/engineering-blog/postgres-jso…
• FOSS4G foss4g.org
• OpenStreetMap openstreetmap.org
• PgDay Boston 2026.pgdayboston.org
• SKILL.md file github.com/postgis/postgis/blob/68dde711039986…
• Production query plans without production data (blog post by Radim Marek) boringsql.com/posts/portable-stats
• PostgreSQL: Up and Running, 4th Edition (by Regina Obe, Leo Hsu) oreilly.com/library/view/postgresql-up-and/979…

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With credit to:
• Jessie Draws for the elephant artwork