[postgis-users] raster question

[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? 
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