Hi all, I've been searching around for an answer to this, but I coulnd't find anything. So here we go. I am running PostgreSQL 8.1.3 on Red Hat on an Intel server with 2GB of RAM and lot of free HD space. I have a very large dump file, more then 4GB, to recreate a database. When I run: psql -Uuser -q -dmydatabase <mydump.sql & It works, but is slow, it inserts about 1.000 record in 10 seconds. But the curious thing is that if I check the resources of the server it seems that psql is not using them much. "top" says that postgres is using around 2% of the processor and psql around 1% so that server is only 3% used. "top" also says that more or less 48% idle and 50%waiting... In the other hand the memory seems to be very high... What could be the problem? Is that the server is just slow reading from the file? It has a 300GB SCSI drive. Is there any way to make this work faster? I would like to recreate the db at least once a month, but this taked too much time... Thanks in advance for any advice. Javier.
