[postgis-users] OT: moving my access data into postgis

Tyler Mitchell TMitchell at lignum.com
Wed Aug 21 08:44:24 PDT 2002


Slightly off topic, but relevant nonetheless.
I've got a ton of data in an MS Access database and I've been using the
postgresql odbc driver to export the data into a postgis database.  But
man, it's really, really slow.   You thought gist indexing of large tables
was slow!  Well, I'm looking at 1-2 hours for half a million records with
only 4 integer columns.

Can you suggest a better method of moving out of Access?






More information about the postgis-users mailing list