PostGIS vs ArcSDE: raster load speed test (preparation)

09.06.2009 12:03 ·  GIS  ·  postgis, wktraster

Recently, PostGIS has received support for raster data and the ability to load images directly into the database through the WKTRaster extension. This is one of the features that previously fell short compared to ArcSDE.

As soon as raster support became available, it was natural to want to compare PostGIS and ArcSDE. When I saw a forum topic about it, I immediately volunteered to help.

Today I spent most of the day preparing: I downloaded source archives, read installation instructions, and compiled all necessary components. There were a few pitfalls: first, PostgreSQL 8.3.7 refused to compile, saying that utf8_and_shift_jis_2004.o could not be built. After some investigation, I found that the following files are missing

../src/backend/utils/mb/conversion_procs/utf8_and_shift_jis_2004/utf8_and_shift_jis_2004.c
../src/backend/utils/mb/conversion_procs/euc_jis_2004_and_shift_jis_2004/euc_jis_2004_and_shift_jis_2004.с

More precisely, they are present, but not in the src directory where the compiler looks for them, but in a completely different location. After moving these files to the correct directory, the compilation was successfully completed. I described the compilation process in detail in the previous post.

All other components were compiled without any issues, the only trouble was that the archive with the SVN version of PostGIS turned out to be “broken”, so I had to re-download it.

The test data set has been downloaded, and all the components have been built. Now I am waiting for the test instructions.

To be continued…