[postgis-users] Help: Fastest way to load data.

Nicolas RIBOT nri at scot.cnes.fr
Thu Feb 19 01:12:56 PST 2004


> Hi
> 
> I'm trying to import 2 million rows of WKT spatial data into 
> a database. I
> was just wondering what the faster way to do this i.e. copy 
> or inserts. If
> anyone has any tips it would be greatly appreciated. 
> 

Hi, 
copy is much, much faster than inserts.

Nicolas Ribot



More information about the postgis-users mailing list