Lonni J Friedman netll...@gmail.com wrote:
top shows over 90% of the load is in sys space. vmstat output
seems to suggest that its CPU bound (or bouncing back forth):
Can you run `perf top` during an episode and see what kernel
functions are using all that CPU?
This looks similar to cases
On Wed, Sep 18, 2013 at 2:02 AM, Kevin Grittner kgri...@ymail.com wrote:
Lonni J Friedman netll...@gmail.com wrote:
top shows over 90% of the load is in sys space. vmstat output
seems to suggest that its CPU bound (or bouncing back forth):
Can you run `perf top` during an episode and see
On Wed, Sep 18, 2013 at 2:02 AM, Kevin Grittner kgri...@ymail.com wrote:
Lonni J Friedman netll...@gmail.com wrote:
top shows over 90% of the load is in sys space. vmstat output
seems to suggest that its CPU bound (or bouncing back forth):
Can you run `perf top` during an episode and see
On Wed, Sep 18, 2013 at 10:30 AM, Lonni J Friedman netll...@gmail.comwrote:
This looks similar to cases I've seen of THP defrag going wild.
Did the OS version or configuration change? Did the PostgreSQL
memory settings (like shared_buffers) change?
I think you're onto something here
Greetings,
I'm running a PostgreSQL 9.3.0 cluster (1 master with two streaming
replication hot standby slaves) on RHEL6-x86_64. Yesterday I upgraded
from 9.2.4 to 9.3.0, and since the upgrade I'm seeing a significant
performance degradation. PostgreSQL simply feels slower. Nothing
other than
On Tue, 17 Sep 2013 09:19:29 -0700
Lonni J Friedman netll...@gmail.com wrote:
Greetings,
I'm running a PostgreSQL 9.3.0 cluster (1 master with two streaming
replication hot standby slaves) on RHEL6-x86_64. Yesterday I upgraded
from 9.2.4 to 9.3.0, and since the upgrade I'm seeing a
On Tue, Sep 17, 2013 at 9:54 AM, Eduardo Morras emorr...@yahoo.es wrote:
On Tue, 17 Sep 2013 09:19:29 -0700
Lonni J Friedman netll...@gmail.com wrote:
Greetings,
I'm running a PostgreSQL 9.3.0 cluster (1 master with two streaming
replication hot standby slaves) on RHEL6-x86_64. Yesterday I
On Tue, Sep 17, 2013 at 11:22 AM, Lonni J Friedman netll...@gmail.comwrote:
c) What does logs say?
The postgres server logs look perfectly normal, minus a non-trivial
slower run time for most queries. There's nothing unusual in any of
the OS level logs (/var/log/messages, etc) or dmesg.
Thanks for your reply. Comments/answers inline below
On Tue, Sep 17, 2013 at 11:28 AM, Jeff Janes jeff.ja...@gmail.com wrote:
On Tue, Sep 17, 2013 at 11:22 AM, Lonni J Friedman netll...@gmail.com
wrote:
c) What does logs say?
The postgres server logs look perfectly normal, minus a
Hi,
On 2013-09-17 09:19:29 -0700, Lonni J Friedman wrote:
I'm running a PostgreSQL 9.3.0 cluster (1 master with two streaming
replication hot standby slaves) on RHEL6-x86_64. Yesterday I upgraded
from 9.2.4 to 9.3.0, and since the upgrade I'm seeing a significant
performance degradation.
On Tue, Sep 17, 2013 at 3:47 PM, Andres Freund and...@2ndquadrant.com wrote:
Hi,
On 2013-09-17 09:19:29 -0700, Lonni J Friedman wrote:
I'm running a PostgreSQL 9.3.0 cluster (1 master with two streaming
replication hot standby slaves) on RHEL6-x86_64. Yesterday I upgraded
from 9.2.4 to
11 matches
Mail list logo