Creating spatial indexes on geography slower than on geometry?

Marco Boeringa <[email protected]>
Newsgroups gmane.comp.gis.postgis
Message-ID <[email protected]>
Hi,

I wondered if this is a known issue with geography. Up to now, I have 
always been using geometry but as a test with the new osm2pgsql v2.0.0, 
I have loaded Planet data of OpenStreetMap using geography. While most 
of that operation is about the same speed as with geometry, I see the 
creation of spatial indexes (GiST) on geography, taking about 2.5x times 
the amount of time it took on geometry.

I appreciate geography is not geometry, and the underlying technical 
implementation details of the two may well explain the difference, but I 
am just wondering if someone can confirm this is a normal and expected 
observation for the difference between these two storage options 
regarding indexing.

Marco
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.