Re: [postgis-users] raster question

2016-03-11 Thread Pierre Racine
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

[postgis-users] raster question

2016-03-10 Thread Stephen Crawford
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?