=== Without where clause - after approx 30 secs. last pid: 76929; load averages: 0.72, 0.61, 0.43 up 8+00:45:17 22:46:51 43 processes: 2 running, 41 sleeping CPU states: 24.9% user, 0.0% nice, 0.2% system, 0.1% interrupt, 74.8% idle Mem: 148M Active, 996M Inact, 131M Wired, 87M Cache, 112M Buf, 454M Free Swap: 4095M Total, 284K Used, 4094M Free PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 76889 pgsql 102 0 473M 271M CPU1 1 11:27 87.60% 87.60% postgres 577 root 96 0 95780K 94344K select 3 15:09 0.00% 0.00% Xorg 502 root 96 0 5664K 1848K select 3 0:27 0.00% 0.00% nmbd === Without where clause - shortly before succesfull completion. last pid: 76929; load averages: 0.97, 0.75, 0.51 up 8+00:47:34 22:49:08 43 processes: 2 running, 41 sleeping CPU states: 24.7% user, 0.0% nice, 0.3% system, 0.0% interrupt, 75.0% idle Mem: 375M Active, 996M Inact, 181M Wired, 87M Cache, 112M Buf, 177M Free Swap: 4095M Total, 284K Used, 4094M Free PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 76889 pgsql 106 0 705M 498M CPU0 0 13:44 99.02% 99.02% postgres 577 root 96 0 95780K 94344K select 3 15:09 0.00% 0.00% Xorg 502 root 96 0 5664K 1848K select 0 0:27 0.00% 0.00% nmbd 435 root 96 0 3636K 2164K select 1 0:16 0.00% 0.00% sendmail === Without where clause - shortly after succesfull completion. last pid: 76929; load averages: 0.95, 0.65, 0.43 up 8+00:43:37 22:45:11 43 processes: 1 running, 42 sleeping CPU states: 20.9% user, 0.0% nice, 6.4% system, 0.5% interrupt, 72.2% idle Mem: 67M Active, 996M Inact, 121M Wired, 87M Cache, 112M Buf, 545M Free Swap: 4095M Total, 284K Used, 4094M Free PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 76889 pgsql 4 0 382M 190M sbwait 0 10:46 98.97% 98.97% postgres 577 root 96 0 95780K 94344K select 3 15:09 0.00% 0.00% Xorg === With where clause - after 30 secs last pid: 76910; load averages: 0.48, 0.35, 0.19 up 8+00:33:30 22:35:04 43 processes: 2 running, 41 sleeping CPU states: 25.0% user, 0.0% nice, 0.1% system, 0.1% interrupt, 74.8% idle Mem: 135M Active, 1151M Inact, 123M Wired, 99M Cache, 112M Buf, 308M Free Swap: 4095M Total, 284K Used, 4094M Free PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 76889 pgsql 102 0 464M 258M CPU2 2 3:37 79.93% 79.93% postgres 577 root 96 0 95780K 94344K select 3 15:09 0.00% 0.00% Xorg 502 root 96 0 5664K 1848K select 1 0:27 0.00% 0.00% nmbd 435 root 96 0 3636K 2164K select 0 0:16 0.00% 0.00% sendmail 530 root 96 0 1284K 680K select 1 0:04 0.00% 0.00% moused 68330 root 96 0 5592K 4404K select 2 0:04 0.00% 0.00% cupsd === With where clause - just before crash last pid: 76910; load averages: 0.99, 0.71, 0.38 up 8+00:37:31 22:39:05 43 processes: 2 running, 41 sleeping CPU states: 24.5% user, 0.0% nice, 0.8% system, 0.0% interrupt, 74.7% idle Mem: 550M Active, 996M Inact, 168M Wired, 99M Cache, 112M Buf, 3232K Free Swap: 4095M Total, 284K Used, 4094M Free PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 76889 pgsql 107 0 881M 674M CPU0 0 7:38 99.02% 99.02% postgres 577 root 96 0 95780K 94344K select 3 15:09 0.00% 0.00% Xorg 502 root 96 0 5664K 1848K select 2 0:27 0.00% 0.00% nmbd 435 root 96 0 3636K 2164K select 0 0:16 0.00% 0.00% sendmail === With where clause - just after crash last pid: 76913; load averages: 0.39, 0.59, 0.35 up 8+00:38:31 22:40:05 43 processes: 1 running, 42 sleeping CPU states: 0.0% user, 0.0% nice, 0.3% system, 0.1% interrupt, 99.6% idle Mem: 67M Active, 996M Inact, 122M Wired, 87M Cache, 112M Buf, 545M Free Swap: 4095M Total, 284K Used, 4094M Free PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 76889 pgsql 4 0 382M 190M sbwait 0 7:45 6.30% 6.30% postgres 577 root 96 0 95780K 94344K select 3 15:09 0.00% 0.00% Xorg 502 root 96 0 5664K 1848K select 3 0:27 0.00% 0.00% nmbd 435 root 96 0 3636K 2164K select 3 0:16 0.00% 0.00% sendmail 530 root 96 0 1284K 680K select 1 0:04 0.00% 0.00% moused 68330 root 96 0 5592K 4404K select 2 0:04 0.00% 0.00% cupsd