I don't know about data warehousing with spatial data, but two guys I was taking two a couple of months ago were both working on web apps that worked with geospatial data. Both of them were using postgres for geospatial use and endorsed it over both mySQL and MS-SQL.