11-04, 13:00–13:30 (America/New_York), Lake Fairfax
Will discuss some tricks for getting better performance out of your spatial postgis queries
- postgis - the core extension
- postgis_raster
- postgis_topology
- postgis_sfcgal
- postgis_tiger_geocoder
In this talk I'll go over
- Spatial index in combination with other indexes.
- Materialized views
- Writing performant queries
- Using processing functions to minimize weight of geometries
Regina is a member of the PostGIS, pgRouting, and GEOS open source geospatial projects.
She is also a member of the Open Source Geospatial (OSGeo) system administration committee.
She is an co-author with her husband Leo Hsu of several books on PostgreSQL, PostGIS, pgRouting, and SQL.
She is also president of Paragon Corporation https://www.paragoncorporation.com which provides consulting and application development services for PostGIS and PostgreSQL.