Solved

CLUSTER Postgres relation on gist index

Posted on 2014-11-17
2
266 Views
Last Modified: 2014-11-20
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
Comment
Question by:DerekWatling
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Accepted Solution

by:
DerekWatling earned 0 total points
ID: 40454515
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to check sequence missing in postgress 9 177
Linux Server Backup Guidance 4 288
postgres windows server monitoring solution 2 98
Postgres Joining 10 70
I feel like more and more people want to know how to programmatically convert addresses into geospatial locations. So in this article, I will show you how you can do it with Bing Maps. I'm going to use PowerShell, which is a nice scripting language,…
Introduction This article is designed to assist GIS (Geographic Information System) and GPS (Global Positioning System) developers using ESRI ArcGIS and other spatial information management systems.   For the uninitiated the concept of projectio…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
Suggested Courses

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question