Tom Lane wrote:
Hm, not really a smoking gun there. But just for grins, would you try this patch and see if the numbers change?
Applied to 8.2.3 (don't have lineitem loaded in HEAD yet) - no change that I can see:
procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu---- r b swpd free buff cache si so bi bo in cs us sy id wa 1 0 764 55300 0 1988032 0 0 118797 32 1532 1775 15 39 44 2 1 0 764 54476 0 1989720 0 0 115507 9 1456 3970 15 39 45 1 1 0 788 54540 0 1989592 0 0 121651 0 1508 3221 16 37 47 0 1 0 788 52808 0 1991320 0 0 124109 0 1532 1236 15 38 46 0 1 0 788 52504 0 1991784 0 0 124518 0 1547 1005 16 39 45 0 2 0 788 54544 0 1989740 0 5 117965 5 1491 2012 15 36 47 2 1 0 788 53596 0 1991184 0 0 120424 0 1504 1910 16 37 46 1
Elapsed time is exactly the same (101 s). Is is expected that HEAD would behave differently?
Cheers Mark ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
