Show filters Hide filters

Refine your search

Publication Year
Author & Contributors
Image Motifs found in the video
1-1 out of 1 results
Change view
  • Sort by:
22:59 FOSS4G, Open Source Geospatial Foundation (OSGeo) English 2013

Optimising Spatial Data Analysis With PostgreSQL And PostGIS

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.
  • Published: 2013
  • Publisher: FOSS4G, Open Source Geospatial Foundation (OSGeo)
  • Language: English
out of 1 pages
Loading...
Feedback

Timings

   39 ms - page object
   22 ms - search
    1 ms - highlighting
    1 ms - highlighting/15571

Version

AV-Portal 3.7.0 (943df4b4639bec127ddc6b93adb0c7d8d995f77c)