[postgis-devel] PostGIS-on-GSERIALIZED

Paul Ramsey pramsey at cleverelephant.ca
Wed Dec 22 14:47:32 PST 2010

Well, I have now completed an alpha integration of PostGIS with
GSERIALIZED storage. To try it, edit ./postgis/gserialized.h and
change #undef to #define. Then make clean and make, and install into a
fresh database.

It currently fails 4 regression tests, but I think those are
"legitimate" failures. Several are memsize() tests, and the memory
size of these objects happen to be different from the old ones.
Another few are differences in 'box2d' representations, because I
changed the backing type for 'box2d' from BOX2DFLOAT4 to GBOX, so the
storage is now double and not float. So they are just more precise.
The final one is an obscure oddity in ST_Dump, which expects that the
dump of a collection of empty things will have zero entries. And
instead it has one entry for every non-collection element in the

There is a default index implementation, but it's currently n-d, not 2-d.

Anyhow, it builds! It regresses! When do we pull off the band-aid and
all start working on making this production ready?


More information about the postgis-devel mailing list