[postgis-users] raster2pgsql vs gdal2wktraster ...can someone clarify?

[Pierre Racine]

>> Be carefull here as PostGIS raster was not really intented to do this kind
>> of operation on so small images. It's like using a bazooka to kill a fly.
>> Many GIS packages will allow you to do this simple operation much easier
>> than PostGIS...
>>
>> Why do you feel the need to use PostGIS for that?
>>> Ah well I am using PostGIS already, as part of handling other vector data
>>> sets etc....this raster image is just one side to it - besides, there
>>> would be other images which would be bigger, and also, one has to start
>>> somewhere to test whether it works. Before I stumbled upon Postgis
>>> Raster, the other option was for me to transform the raster image to
>>> vector data with attributes - but I want to see how well Postgis Raster
>>> works for me. I need to be able to dynamically query my datasets (e.g.
>>> vector data + raster images).

Then PostGIS raster is probably the right choice. And you should use the -k option something like "-k 25x25" and see the results and performance.

Pierre