Oracle GIS database replacement My company has a huge (hundreds of millions of records) Oracle database of GIS/temporal information.  We are trying to switch to an open source alternative.

If it helps, we imagined the following requirements:


horizontal scaling (like elastic search, for example)
fully SQL compliant. We don't think we can use NoSQL, etc, because we would have to rewrite all our queries.
No license fee
No database is fully SQL compliant. But out of the SQL databases that provide any form of scaling you have PostgreSQL w/ PostGIS and MySQL to choose from.

PostGIS is the superior choice. For why see my comparison here.