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.
FYI there's top output on the same server with only 2 cores enabled (it works
much better than with 8 cores):
last pid: 38266; load averages: 7.11, 5.01, 4. up 0+01:33:40 15:51:20
53 processes: 7 running, 46 sleeping
CPU: 69.1% user, 0.0% nice, 29.8% system, 0.4% interrupt, 0.7% idle
Mem: 835M Active, 1743M Inact, 443M Wired, 168K Cache, 214M Buf, 882M Free
Swap: 2048M Total, 2048M Free
PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAN
38139 pgsql 1 132 0 1126M 639M RUN 0 0:06 29.84% postgr
38245 pgsql 1 130 0 1071M 361M RUN 1 0:01 19.61% postgr
38249 pgsql 1 130 0 1068M 320M CPU1 0 0:01 15.76% postgr
38251 pgsql 1 130 0 1069M 317M RUN 1 0:01 15.06% postgr
38254 pgsql 1 130 0 1067M 161M RUN 1 0:01 14.36% postgr
694 pgsql 1 130 0 1066M 4816K select 0 0:37 0.00% postgr
698 pgsql 1 96 0 15588K 4724K select 0 0:28 0.00% postgr
697 pgsql 1 96 0 1066M 298M select 0 0:14 0.00% postgr
1748 root 1 96 0 7044K 2252K select 0 0:05 0.00% top
18775 root 1 96 0 7008K 2220K select 0 0:02 0.00% top
627 root 1 96 0 18120K 5872K select 0 0:02 0.00% snmpd
1704 vich 1 96 0 30616K 4248K select 0 0:00 0.00% sshd
695 pgsql 1 96 0 15392K 4496K select 1 0:00 0.00% postgr
16781 null 1 96 0 30616K 4220K select 0 0:00 0.00% sshd
655 root 1 96 0 7732K 2324K select 0 0:00 0.00% ntpd
556 root 1 96 0 3652K 1192K select 1 0:00 0.00% syslog
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]"