Re: [PERFORM] Slow update/insert process

2004-10-04 Thread Patrick Hatcher
Hatcher <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/01/04 11:14 AM To <[EMAIL PROTECTED]> cc Subject [PERFORM] Slow update/insert process Pg: 7.4.5 RH 7.3 8g Ram 200 g drive space RAID0+1 Tables vacuum on a nightly basis The following process below take

Re: [PERFORM] Slow update/insert process

2004-10-01 Thread Aaron Werman
Sent: Friday, October 01, 2004 2:14 PM Subject: [PERFORM] Slow update/insert process Pg: 7.4.5 RH 7.3 8g Ram 200 g drive space RAID0+1 Tables vacuum on a nightly basis The following process below takes 8 hours to run on 90k records and I'm not sure where to being to loo

[PERFORM] Slow update/insert process

2004-10-01 Thread Patrick Hatcher
Pg: 7.4.5 RH 7.3 8g Ram 200 g drive space RAID0+1 Tables vacuum on a nightly basis The following process below takes 8 hours to run on 90k records and I'm not sure where to being to look for the bottleneck.  This isn't the only updating on this database that seems to take a long time to complete.