[postgis-devel] [PostGIS] #944: typmod support for PostGIS geometry

PostGIS trac at osgeo.org
Fri May 13 03:42:46 PDT 2011


#944: typmod support for PostGIS geometry
-------------------------+--------------------------------------------------
 Reporter:  robe         |       Owner:  pramsey      
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.0.0
Component:  postgis      |     Version:  trunk        
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by robe):

 1) Automation is not what I was worrying about.  I was more worried about
 speed.
 For example converting a varchar(50) to say a varchar(1000) takes a
 painful amount of time for a large table.  OF course I may be over
 estimating this.  I think if Paul goes ahead with the typmod, I can test
 with a 10 million record table converting to typmod to see just how
 painful it is.

 I really think we should avoid updating the catalogs directly.  too much
 has changed betweenn 8.4-9.1 that I wouldn't want to risk screwing it up.
 Besides the PostgreSQL devs really frown on those changes.

 2) Okay I can concede to that.  It's a bit inconvenient than using
 addgeometrycolumn but I agree it's a more advanced use case and rare at
 that.

 3) I think a lot of the speed issues we have addressed for this.  In the
 past it was significantly faster doing checks with polygons than
 multipolygons even when a multipolygon had only one polygon.  This is
 probalby more an issue with third party tools than PostGIS.

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


More information about the postgis-devel mailing list