<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Thank you </div><div class=""><br class=""></div>I’ve filed this as a defect 3501<div class=""><br class=""></div><div class=""><br class=""></div><div class="">regards </div><div class=""><br class=""></div><div class="">—kit</div><div class=""><br class=""></div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On 11 Mar 2016, at 15:53, Bborie Park <<a href="mailto:dustymugs@gmail.com" class="">dustymugs@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Wow... that's new. I'm guessing that the array that collects the individual tiles' extents is getting too big. Can you file a ticket?</div><div class="gmail_extra"><br class=""><div class="gmail_quote">On Fri, Mar 11, 2016 at 12:08 AM, Caitríona Smith <span dir="ltr" class=""><<a href="mailto:kit@hypostasis.com" target="_blank" class="">kit@hypostasis.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class=""><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">Hi All</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">I’ve a number of largish rasters that I’m wanting to tile to relatively small tiles, but I’m hitting the array limit on the add maximum extent constraint. </div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">If the tile_size is 32x32 or 50x50 I get the error, but a tile size of 64x64 completes. </div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">At 50x50 there are 13M rows and at 64x64 there are 8M</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">I’m wanting to use fairly small tiles as I am intending to version control the data at the tile level, and would prefer to keep the area that doesn’t change under control to a minimum.</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">I’m thinking that I might be able to get away with a parent child relationship, and that I may have to do that anyway, for performance, but I’m not sure what the effect of that will be on the extent constraint. </div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">Is there something else that I am doing wrong, or is there another way around this (I’ve not really looked at the component functions to see what they do)</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">I’m running postgis 2.2.1 on postgres 9.5.1 on SL7.2 for my sins</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><div style="margin:0px;line-height:normal" class=""><br class=""></div><div style="margin:0px;line-height:normal" class=""><br class=""></div><div style="margin:0px;line-height:normal" class=""><div style="margin:0px;line-height:normal" class="">select version();</div><div style="margin:0px;line-height:normal" class=""> version </div><div style="margin: 0px; line-height: normal; min-height: 13px;" class=""> <br class=""></div><div style="margin:0px;line-height:normal" class="">--------------------------------------------------------------------------------</div><div style="margin:0px;line-height:normal" class="">-------------------------</div><div style="margin:0px;line-height:normal" class=""> PostgreSQL 9.5.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (</div><div style="margin:0px;line-height:normal" class="">Red Hat 4.8.5-4), 64-bit</div><div style="margin:0px;line-height:normal" class="">(1 row)</div><div class=""><br class=""></div></div><div style="margin:0px;line-height:normal" class=""><br class=""></div><div style="margin:0px;line-height:normal" class=""><br class=""></div><div style="margin:0px;line-height:normal" class=""><br class=""></div><div style="margin:0px;line-height:normal" class="">select postgis_full_version();</div><div style="margin:0px;line-height:normal" class=""> post</div><div style="margin:0px;line-height:normal" class="">gis_full_version </div><div style="margin: 0px; line-height: normal; min-height: 13px;" class=""> <br class=""></div><div style="margin:0px;line-height:normal" class="">--------------------------------------------------------------------------------</div><div style="margin:0px;line-height:normal" class="">--------------------------------------------------------------------------------</div><div style="margin:0px;line-height:normal" class="">------------</div><div style="margin:0px;line-height:normal" class=""> POSTGIS="2.2.1 r14555" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.8.0, 6 March </div><div style="margin:0px;line-height:normal" class="">2012" GDAL="GDAL 1.11.4, released 2016/01/25" LIBXML="2.9.1" LIBJSON="0.11" TOPO</div><div style="margin:0px;line-height:normal" class="">LOGY RASTER</div><div style="margin:0px;line-height:normal" class="">(1 row)</div><div class=""><br class=""></div></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">hmdb=> select count(*) from dtm2015_50x50;</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""> count </div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">----------</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""> 13360464</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">(1 row)</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><div style="margin:0px;line-height:normal" class="">hmdb=> select count(*) from dtm2015;</div><div style="margin:0px;line-height:normal" class=""> count </div><div style="margin:0px;line-height:normal" class="">---------</div><div style="margin:0px;line-height:normal" class=""> 8152320</div><div style="margin:0px;line-height:normal" class="">(1 row)</div><div style="margin:0px;line-height:normal;min-height:13px" class=""><br class=""></div></div><div class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">hmdb=> select addrasterconstraints('dtm2015_50x50'::name, 'rast'::name); </div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">NOTICE: Adding SRID constraint</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">CONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">NOTICE: Adding scale-X constraint</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">CONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">NOTICE: Adding scale-Y constraint</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">CONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">NOTICE: Adding blocksize-X constraint</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">CONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">NOTICE: Adding blocksize-Y constraint</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">CONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">NOTICE: Adding alignment constraint</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">CONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">NOTICE: Adding number of bands constraint</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">CONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">NOTICE: Adding pixel type constraint</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">CONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">NOTICE: Adding nodata value constraint</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">CONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">NOTICE: Adding out-of-database constraint</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">CONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">NOTICE: Adding maximum extent constraint</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">CONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">ERROR: array size exceeds the maximum allowed (1073741823)</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">CONTEXT: SQL statement "SELECT st_ashexewkb(st_envelope(st_collect(st_envelope(rast)))) FROM cjsmith.dtm2015_50x50"</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">PL/pgSQL function _add_raster_constraint_extent(name,name,name) line 20 at EXECUTE</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">PL/pgSQL function addrasterconstraints(name,name,name,text[]) line 104 at assignment</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class=""></div><div class=""><br class=""></div></div><br class="">_______________________________________________<br class="">
postgis-users mailing list<br class="">
<a href="mailto:postgis-users@lists.osgeo.org" class="">postgis-users@lists.osgeo.org</a><br class="">
<a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank" class="">http://lists.osgeo.org/mailman/listinfo/postgis-users</a><br class=""></blockquote></div><br class=""></div>
_______________________________________________<br class="">postgis-users mailing list<br class=""><a href="mailto:postgis-users@lists.osgeo.org" class="">postgis-users@lists.osgeo.org</a><br class="">http://lists.osgeo.org/mailman/listinfo/postgis-users</div></blockquote></div><br class=""></div></body></html>