[postgis-devel] [PostGIS] #1991: geocode really slow on PostgreSQL 9.2

[PostGIS]

#1991: geocode really slow on PostgreSQL 9.2
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.2
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by robe):

 Okay it seems in 9.2, reducing the join collapse limit makes it behave as
 fast as the old versions

 e.g.:

 {{{
  SET join_collapse_limit = '2';
 }}}

 Make both queries work at the faster speed and use the bitmapor strategy
 again.So not sure this is a real issue or just something to be cognizant
 of.

 The default is 8, but if I increase above 4 it gets bad.

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