[postgis-tickets] [PostGIS] #4372: PROJ 6: 4x slowdown on indexes over ST_Transform

[PostGIS]

#4372: PROJ 6: 4x slowdown on indexes over ST_Transform
-------------------------+---------------------------
  Reporter:  Algunenano  |      Owner:  Algunenano
      Type:  defect      |     Status:  assigned
  Priority:  high        |  Milestone:  PostGIS 3.0.0
 Component:  postgis     |    Version:  trunk
Resolution:              |   Keywords:
-------------------------+---------------------------

Comment (by Algunenano):

 I've just noticed (trying proj6.1 again) that I get a lot of warning in
 postgres logs:
 {{{
 jun 14 12:31:13 Mordor postgres[27104]:
 proj_create_operation_factory_context: Cannot find proj.db
 jun 14 12:31:13 Mordor postgres[27104]: pj_obj_create: Cannot find proj.db
 jun 14 12:31:13 Mordor postgres[27104]: proj_create: Cannot find proj.db
 jun 14 12:31:13 Mordor postgres[27104]: proj_create: no database context
 specified
 jun 14 12:31:13 Mordor postgres[27104]: proj_create: Cannot find proj.db
 jun 14 12:31:13 Mordor postgres[27104]:
 proj_create_operation_factory_context: Cannot find proj.db
 jun 14 12:31:13 Mordor postgres[27104]: pj_obj_create: Cannot find proj.db
 jun 14 12:31:13 Mordor postgres[27104]: proj_create: Cannot find proj.db
 jun 14 12:31:13 Mordor postgres[27104]: proj_create: no database context
 specified
 jun 14 12:31:13 Mordor postgres[27104]: proj_create: Cannot find proj.db
 jun 14 12:31:13 Mordor postgres[27104]:
 proj_create_operation_factory_context: Cannot find proj.db
 jun 14 12:31:13 Mordor postgres[27104]: pj_obj_create: Cannot find proj.db
 }}}


 My proj installation seems to be ok according to proj.pc:
 {{{
 cat /usr/lib/pkgconfig/proj.pc
 prefix=/usr
 exec_prefix=${prefix}
 libdir=${exec_prefix}/lib
 includedir=${prefix}/include
 datadir=${prefix}/share/proj

 Name: proj
 Description: Cartographic Projections Library.
 Requires:
 Version: 6.1.0
 Libs: -L${libdir} -lproj
 Cflags: -I${includedir}
 }}}

 proj.db is in `/usr/share/proj/proj.db`, which matches
 `${prefix}/share/proj/proj.db`.

 I'm trying to understand if I need to setup an env variable, but I was
 expecting this to be automatic.

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