[postgis-tickets] [PostGIS] #2260: Benchmarking speed between built-in tiger normalizer and pagc_address_parser

[PostGIS]

#2260: Benchmarking speed between built-in tiger normalizer and
pagc_address_parser
---------------------------------+------------------------------------------
 Reporter:  robe                 |       Owner:  robe         
     Type:  task                 |      Status:  new          
 Priority:  medium               |   Milestone:  PostGIS 2.1.0
Component:  pagc_address_parser  |     Version:  trunk        
 Keywords:                       |  
---------------------------------+------------------------------------------

Comment(by robe):

 Regarding above -- what happens if you take out the --enable-debug
 recompiling mine withot cassert or debug but haven't retested yet.

 okay I stand corrected about prior statement, its a bit more complicated.

 1) Both old and new fail in my mingw64 with cassert enabled
 2) On VC EDB install with my last sample test:

 {{{
 SELECT *
 FROM standardize_address('select * from lex', 'select * from gaz', 'select
 * from rules'
         , 'SELECT addid As id, (p).address1 As micro, (p).city || '', ''
 || (p).state || '' '' || coalesce('' '' || (p).zip,'''') As macro
 FROM (SELECT addid, parse_address(address) As p
 FROM test_parse WHERE addid NOT IN(3) ) As t ');
 }}}


  above works fine but when wrapped into my plpgsql pagc_normalize_address
 packaged with tiger geocoder:

 {{{
 SELECT address, pagc_normalize_address(address)
 FROM test_parse;
 }}}

 old works new crashes.

 Can you try the tiger goecoder pagc_normalize_address on your linux.

 If you don't have 2.1 compiled just pull the
 share/extension/postgis_tiger_geocoder* files from

 http://winnie.postgis.net/download/windows/pg92/buildbot/
 (should work on your Linux as well since its all plpgsql)


 {{{
 CREATE EXTENSION postgis_tiger_geocoder;
 }}}

 Then you should be able to run the above test on linux as well and
 HOPEFULLY we'll find a similar issue on Linux that is easier to debug than
 it is on windows.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2260#comment:19>
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.