Using some of PostGIS's resampling capabilities, we projected the MODIS raster to a different spatial reference with ST_Transform() as well as controlled the quality of the projected raster. We also created an overview with ST_Rescale().
Using these functions and other PostGIS resampling functions, you should be able to manipulate all the rasters.