[postgis-users] raster question

Stephen Crawford src176 at psu.edu
Thu Mar 10 09:05:14 PST 2016

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 

Any thoughts?


Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University

More information about the postgis-users mailing list