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.
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