[postgis-users] Importing large GeoTIFFs best practices

Giuseppe Broccolo g.broccolo.7 at gmail.com
Fri Dec 22 01:18:03 PST 2017


Hi Антон,

2017-12-21 20:13 GMT+01:00 Антон Брюхов <asbryukhov at gmail.com>:

> Greetings,
>
> What is best way to import and work (in terms of performance
> and convenience) with large GeoTIFF rasters (~9000x9000). Is it better to
> register them as out-db rasters or not? Is it a good practice to cut big
> rasters in tiles and process them in that way?
>

IMHO it is better to work with an higher granularity (i.e. smaller raster's
size) in order to improve caching of tiles, etc., and keep them in the db,
that will efficiently provide them basing on spatial queries.

All the best,
Giuseppe.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171222/acdbe5fb/attachment.html>


More information about the postgis-users mailing list