Optimising Spatial Data Analysis With PostgreSQL And PostGIS

Gianni Ciolli (2ndQuadrant) with Simon Riggs (2ndQuadrant)

15:00 on Friday 20th September (in Session 44, starting at 2 p.m., Sir Clive Granger Building: A41)

Show in Timetable

Description: We describe the solution of some PostGIS problems, demonstrating relevant PostgreSQL features which include: GiST and SP-GiST index types; custom database objects; query and workload profiling.

In this talk we will demonstrate spatial data analysis on the relational database system PostgreSQL (http://www.postgresql.org) equipped with the spatial extension PostGIS (http://www.postgis.org). We will gradually introduce some of the optimisation techniques provided by PostgreSQL, by applying them to the solution of increasingly complex problems belonging to the PostGIS domain. Our aim is to point out as clearly as possible the main ideas behind each example, showing the link in both projects between development of new features and the need to tackle real-world problems. Topics mentioned in this talk include: the special index types GiST and SP-GiST; custom database objects, such as data types, functions and operators; query and workload profiling.