2 x quad-core system is slower that 2 x dual core on FreeBSD

[Alexey Popov]

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