From: Tom Lane <tgl@sss.pgh.pa.us>
To: Donald C. Sumbry ][ <sumbry@revver.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: High Context-Switches on Linux 8.1.4 Server
Date: Mon, 07 Aug 2006 14:34:41 -0400
Message-ID: <3795.1154975681@sss.pgh.pa.us> (raw)
In-Reply-To: <44D7616D.6080906@revver.com>
References: <44D6EDFA.4030802@revver.com>
<19629.1154955137@sss.pgh.pa.us>
<44D7616D.6080906@revver.com>
>> Is this from LWLock or spinlock contention?
> Over a 20 second interval, I've got about 85 select()s and 6,230
> semop()s. 2604 read()s vs 16 write()s.
OK, so mostly LWLocks then.
>> Do you have any long-running transactions,
> Not long-running. We do have a badly behaving legacy app that is
> leaving some backends "idle in transaction" They're gone pretty quickly
> so I can't kill them fast enough, but running a pg_stat_activity will
> always show at least a handful. Could this be contributing?
Sorry, I was unclear: it's the age of your oldest transaction that
counts (measured by how many xacts started since it), not how many
cycles it's consumed or not.
With the 8.1 code it's possible for performance to degrade pretty badly
once the age of your oldest transaction exceeds 16K transactions. You
were not specific enough about the behavior of this legacy app to let
me guess where you are on that scale ...
> Based on the number of semop's we're getting it does look like
> shared_memory may be getting thrased - any suggestions? We did try
> lowering shared_memory usage in half the previous day,
Unlikely to help --- if it is the pg_subtrans problem, the number of
buffers involved is set by a compile-time constant.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, sumbry@revver.com
Subject: Re: High Context-Switches on Linux 8.1.4 Server
In-Reply-To: <3795.1154975681@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox