hmmm ST_StraightSkeleton() … what to do with it? :)
http://opensciencemap.org/~jeff/test/#scale=17,rot=326,tilt=57,lat=48.855,lon=2.312
I should mention that the large building complex ‘Hôtel des Invalides’ is only one multipolygon tagged with roof:shape=hipped and CGAL takes 15 seconds to compute the skeleton for it.
More about new PostGIS 3D features http://vimeo.com/74869530