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

[Nicolas Ribot]

> 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?

Hi,

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.

Nicolas