Hi Alexey Popov wrote:
Now we also have terribly performing PostgreSQL on 8-core server. We noticed the slowdown after moving PostgreSQL from 2xXeon 3.0 Apache+PostgreSQL server to dedicated PostgreSQL server. I collected some stats (see attach) before moving to Linux.
Sorry for the broken top ouptut in previuos message. Here's the correct one.
last pid: 70857; load averages: 35.05, 37.11, 33 up 25+23:08:00 12:46:29 94 processes: 46 running, 48 sleeping CPU: 17.0% user, 0.0% nice, 80.5% system, 0.2% interrupt, 2.3% idle Mem: 1209M Active, 1890M Inact, 494M Wired, 143M Cache, 214M Buf, 127M Free Swap: 2048M Total, 72K Used, 2048M Free PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAN 70557 pgsql 1 131 0 1068M 662M RUN 0 0:23 26.03% postgr 70840 pgsql 1 132 0 1070M 167M CPU6 5 0:02 21.01% postgr 70761 pgsql 1 128 0 1069M 384M RUN 0 0:04 18.91% postgr 70766 pgsql 1 129 0 1069M 414M RUN 7 0:05 18.17% postgr 70784 pgsql 1 128 0 1071M 374M RUN 3 0:04 17.31% postgr 70758 pgsql 1 128 0 1075M 443M RUN 0 0:05 16.91% postgr 70783 pgsql 1 128 0 1073M 393M RUN 0 0:05 16.86% postgr 70781 pgsql 1 128 0 1073M 389M RUN 0 0:05 16.71% postgr 70755 pgsql 1 128 0 1067M 387M RUN 4 0:05 16.67% postgr 70765 pgsql 1 128 0 1075M 424M CPU5 0 0:05 16.51% postgr 70764 pgsql 1 128 0 1069M 388M RUN 6 0:05 16.45% postgr 70786 pgsql 1 128 0 1069M 361M RUN 1 0:04 16.23% postgr 70785 pgsql 1 128 0 1071M 358M RUN 4 0:04 15.76% postgr 70788 pgsql 1 128 0 1069M 330M RUN 0 0:04 15.46% postgr 70795 pgsql 1 -16 0 1068M 300M vmpfw 0 0:04 15.07% postgr 70803 pgsql 1 128 0 1068M 250M RUN 7 0:03 14.71% postgr 70802 pgsql 1 128 0 1068M 268M RUN 0 0:03 14.19% postgr 70805 pgsql 1 128 0 1068M 249M RUN 0 0:03 14.04% postgr 70798 pgsql 1 128 0 1070M 297M RUN 0 0:03 13.92% postgr 70792 pgsql 1 128 0 1068M 288M RUN 0 0:04 13.90% postgr 70804 pgsql 1 128 0 1068M 238M RUN 0 0:03 13.29% postgr 70808 pgsql 1 128 0 1068M 216M RUN 3 0:03 13.28% postgr 70811 pgsql 1 128 0 1069M 212M RUN 0 0:03 12.81% postgr 70833 pgsql 1 130 0 1068M 133M CPU2 3 0:02 12.77% postgr 70843 pgsql 1 131 0 1068M 57636K RUN 7 0:01 12.13% postgr 70834 pgsql 1 130 0 1068M 111M CPU1 2 0:01 11.53% postgr 70850 pgsql 1 132 0 1067M 46620K RUN 1 0:00 11.28% postgr 70817 pgsql 1 128 0 1068M 150M RUN 0 0:02 10.45% postgr 70844 pgsql 1 131 0 1067M 73296K RUN 4 0:01 10.14% postgr 70815 pgsql 1 128 0 1068M 143M RUN 2 0:01 9.57% postgr 70819 pgsql 1 128 0 1068M 158M RUN 4 0:02 9.43% postgr 70832 pgsql 1 129 0 1067M 99M RUN 1 0:01 9.42% postgr With best regards, Alexey Popov _______________________________________________ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "[EMAIL PROTECTED]"