I've used PostGIS in the past and what I can say is that I was pretty impressed with its performance. If you want to render the geometry, you could use geoserve

I've used PostGIS in the past and what I can say is that I was pretty impressed with its performance. If you want to render the geometry, you could use geoserver... but make sure you have the RAM available.