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 takes 8 hours to run

[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.

Re: [PERFORM] Slow update/insert process

2004-10-01 Thread Aaron Werman
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 look for the bottleneck