[postgis-users] raster question

[Pierre Racine]

Tile them!  Should be much faster.

> -----Original Message-----
> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
> Behalf Of Stephen Crawford
> Sent: Thursday, March 10, 2016 12:05 PM
> To: PostGIS Users Discussion
> Subject: [postgis-users] raster question
> 
> Hell all,
> 
> I have a table of rasters, daily weather data, each record is one full
> raster and an date column, all the same extent.  One of my use cases is
> to drill down to get the all the data for a month or year one grid
> cell.  Performance is slow.  Should I make tiles of these daily rasters?
> I guess I was under the impression that tiles should be used on a "one
> table per raster" basis, and that "many rasters per table" cannot have
> tiles.
> 
> Any thoughts?
> 
> Thanks,
> Steve
> 
> --
> Stephen Crawford
> Center for Environmental Informatics
> The Pennsylvania State University
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users