[postgis-users] RAM requirement of shp2psql and psql command for 368 MB data

Nicolas Ribot nicolas.ribot at gmail.com
Mon Aug 27 06:46:47 PDT 2012

> I haven't got PostGIS installed and have never used it.
> However, I would quickly need to make an estimate of how much RAM
> space would it require to run  shp2psql  and psql -f commands on shape
> dataset, which size is 368 MB.
> Does any experience user have an estimate of how light/ heavy would
> these processes be?


I recall having loaded a ~ 500mb shapefile some years ago without
having to worry about RAM. It took about 20 minutes to load the
polygon layers (huge polygons with million vertices and hundred
thousand holes.


More information about the postgis-users mailing list