I don't know much about GIS software, but I gather that there is an extensive set of extensions to PostgreSQL known as PostGIS which provide a very powerful set of primitives for storing and processing large sets of GIS data.