[postgis-devel] [PostGIS] #1777: revise geocoder structure and functions to utilize 2011 enhancements

[PostGIS]

#1777: revise geocoder structure and functions to utilize 2011 enhancements
-----------------------------+----------------------------------------------
  Reporter:  robe            |       Owner:  robe         
      Type:  enhancement     |      Status:  closed       
  Priority:  medium          |   Milestone:  PostGIS 2.1.0
 Component:  tiger geocoder  |     Version:  trunk        
Resolution:  wontfix         |    Keywords:               
-----------------------------+----------------------------------------------
Changes (by robe):

  * status:  new => closed
  * resolution:  => wontfix


Comment:

 I've decided not to bother with this.  I have the table loaded, but
 thinking of turning the load off by default.  The reason I'm making this
 decidions is

 1) addrfeat (at least for MA seems to be just a join between
 featnames,edges,addr
 so it's denormalized just including edges that are roadways) so it will
 require more disk space to hold dupe edges.

 2) On top of that my left and right are in the same record which means I
 have to do messy case statements to generate separate records where i need
 to.
 3)It's missing the name field which is pretty important the way the
 current geocode is setup (just has fullname)

 3) PostgreSQL is pretty efficient with joins so I don't see much loss of
 time here.  If I were using MySQL which can only handle one index at at
 time, that would be a different story.
 So what I need is to load more data into memory -- this DOES NOT HELP and
 makes things worse since redundant edge geometries will be loaded into
 memory thus occupying valuable real estate space.

 If anyone want's do benchmark to prove me wrong, I'll reconsider.  But
 I've dismissed mostly out of thought process that its not a good fit for
 how PostgreSQL works and better suited for less sophisticated databases.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/1777#comment:4>
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.