
February 3rd, 2003, 05:17 PM
|
|
Junior Member
|
|
Join Date: Dec 2002
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
PostgreSQL - importing data
Hey Guys,
I have a little problem that I am hoping some of you would be able to help me with.
Currently I'm using PostgreSQL 7.0 and PGAdmin 7.1 and i'm importing a bit of data (around 300.000 entries only) spread over 10 tables.
Now, using PGAdmin's import facility is TREMENDOUSLY slow - i mean, on my "slave" machine here (Cel 1.3ghz 256mb ram) it's importing at a rate of 30.000/hour (that's way slow).
Now would anybody here know of a faster way to actually import data (in this case from .csv) from a flat file into postgresql ?
I simply refuse to believe that this is the only way to import it and even tried running a php script from the server through shell but the speed was still rather slow.
Is this just one of postgresql's workhorses or are there ways to improve this performance ?
Thanks folks! cheers
|