Re: CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dennis Brouwer <dennis(dot)brouwer(at)m4n(dot)nl>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load
Date: 2012-09-25 15:57:36
Message-ID: 21048.1348588656@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dennis Brouwer <dennis(dot)brouwer(at)m4n(dot)nl> writes:
> I now have excluded ntp as root cause for the CPU cycles being wasted in
> user space.

Good, cause that wasn't making any sense at all.

> I installed perf and monitored two servers (with different postgresql
> versions and hardware specification) which are "hanging" and have some
> output. Since I'm no die-hard at interpreting the output of perf top what
> would be the next step to do?

I'd suggest asking for help in pgsql-performance. I don't know much
about perf either (still an oprofile guy), but the people who do know
it hang out there.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message P R 2012-09-25 17:19:52 WAL Log Processing For OLAP?
Previous Message Bruce Momjian 2012-09-25 13:10:33 Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed