Tile them! Should be much faster.
> -Original Message-
> From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On
> Behalf Of Stephen Crawford
> Sent: Thursday, March 10, 2016 12:05 PM
> To: PostGIS Users Discussion
> Subject: [postgis-users] raster ques
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?