Webinar: Postgres 12 and PostGIS 3 (5/6)
Below is the recording of my PostgreSQL 12 and PostGIS 3 webinar from February 26, 2020. This is the fifth in a series of six covering how I work with PostGIS and OpenStreetMap.
I had a great time presenting this session, I hope having this recording available is helpful. Below the video is a list the links showing throughout the slides.
Recording
Series complete
This webinar series is completed. See the intro page for the schedule and links to other videos in the series.
Links
Links from the slides in the order they appeared. Sorry for the lack of context in this list right now, I will try to come back to this and provide more context in the future.
- https://blog.rustprooflabs.com/2020/01/postgis-osm-load-2020
- https://explain.depesz.com/s/YzI0
- https://explain.depesz.com/s/6fZA
- https://www.postgresql.org/docs/current/when-can-parallel-query-be-used.html
- https://www.postgresql.org/docs/current/ddl-generated-columns.html
- https://blog.rustprooflabs.com/2019/11/postgres12-postgis3-initial-review
- https://explain.depesz.com/s/9MCv
- https://explain.depesz.com/s/VNbc
- https://www.postgresql.org/docs/current/using-explain.html
- https://blog.rustprooflabs.com/2019/11/postgres12-postgis3-initial-review
- https://paquier.xyz/postgresql-2/postgres-11-covering-indexes/
- https://www.2ndquadrant.com/en/blog/pg12-a-few-special-case-performance-enhancements/
- https://www.postgresql.org/message-id/flat/CAL-OGkthU9Gs7TZchf5OWaL-Gsi%3DhXqufTxKv9qpNG73d5na_g%40mail.gmail.com
- https://postgis.net/docs/manual-dev/ST_TileEnvelope.html
- https://carto.com/blog/MVT-mapnik-vs-postgis/
- https://blog.cleverelephant.ca/2019/08/postgis-3-mvt.html
- https://postgis.net/docs/ST_AsGeoJSON.html
- https://info.crunchydata.com/blog/postgis-3-geojson-st-asgeojson
- https://trac.osgeo.org/geos
- https://gdal.org/
- https://proj.org/
- https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS
- http://postgis.net/docs/postgis_installation.html#hard_upgrade
- https://blog.rustprooflabs.com/2019/12/upgrading-to-postgres12-postgis3-requires-hard-upgrade
- https://www.depesz.com/2019/12/10/how-to-effectively-dump-postgresql-databases/
- https://www.postgresql.org/docs/current/sql-alterdatabase.html
- https://postgis.net/2020/02/20/postgis-3.0.1/
- https://trac.osgeo.org/postgis/ticket/4590
Summary
Need help with your PostgreSQL servers or databases? Want a speaker on the technologies and data I am excited about? Contact us to start the conversation!
Mastodon