[postgis-tickets] [PostGIS] #2918: Use GeographicLib functions for ST_Azimuth, ST_Distance and ST_Project

[PostGIS]

#2918: Use GeographicLib functions for ST_Azimuth, ST_Distance and ST_Project
---------------------+------------------------------------------------------
 Reporter:  mwtoews  |       Owner:  pramsey      
     Type:  patch    |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.2.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by darkblueb):

 some basic timings, which support the timings above:
 {{{
 9.3
  public | tm3_world_borders         | table    | dbb   | 6568 kB    |

 test_geog=# SELECT ST_Area(geog) INTO UNLOGGED foo FROM tm3_world_borders;
 SELECT 246
 Time: 648.776 ms

 select name, st_area(geog) from tm3_world_borders order by name;
 Time: 644.433 ms

 ##----
 9.4b2
  public | tm3_world_borders         | table    | dbb   | 6568 kB    |

 test_geog=# SELECT ST_Area(geog) INTO UNLOGGED foo FROM tm3_world_borders;
 SELECT 246
 Time: 1615.268 ms

 select name, st_area(geog) from tm3_world_borders order by name;
 Time: 1601.604 ms
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2918#comment:12>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.