Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • Last Modified:

CLUSTER Postgres relation on gist index

I am busy learning Postgres with the goal of migrating our current MySQL database to a Postgres/PostGIS spatial database.

We have a table containing (multi)polygons and do a large number of queries that need to find the properties within a given radius of a specific property. In MySQL I have Lat and Lon columns (in radians, of the property centroids) and use the great circle formula to do this.

I was reading about ways of improving performance in Postgres and came across a section titled "Cluster tables on specific indexes".

My question is: Does this work with spatial (gist) indexes to cluster the table by proximity of geometries?
0
DerekWatling
Asked:
DerekWatling
1 Solution
 
DerekWatlingAuthor Commented:
Since there has been no response to my question, I have been doing some more research and came across http://revenant.ca/www/postgis/workshop/indexing.html#clustering-data which states that with the table clustered on a geometry index:
Geometries that are near each other in space are near each other on disk.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now