Have you tried not using inserts but rather use COPY? Just a random idea. Regards On Fri, 2004-05-07 at 12:41, Raymond Burgess wrote:
I am currently importing a lot of data into a Postgres Database. Initially things where quickish, but now it seems to be running very slowly. I put this down to index scans. The machine is a Dual P4 with 2 GB of ram and a Raid array (14 Fibre Channel Harddrives)
Top is reporting the disk cache is 1.7 GB and system idle around 70%. The postgres backend is using 10% to 20% of one CPU. I don't know if the bottleneck is the Disk IO or Ram.
What would people suggest I can look at to see what is holding up the process? _______________________________________________ wlug mailing list | wlug(a)list.waikato.ac.nz Unsubscribe: http://list.waikato.ac.nz/mailman/listinfo/wlug
-- Oliver Jones » Director » oliver.jones(a)deeperdesign.com » +64 (21) 41 2238 Deeper Design Limited » +64 (7) 377 3328 » www.deeperdesign.com