Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

CLUSTER Postgres relation on gist index

Posted on 2014-11-17
2
Medium Priority
?
306 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

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,…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
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…

670 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