Re: commit so slow program looks frozen - Mailing list pgsql-performance

From Richard Troy
Subject Re: commit so slow program looks frozen
Date
Msg-id Pine.LNX.4.33.0610261008290.30114-100000@denzel.in
Whole thread Raw
In response to Re: commit so slow program looks frozen  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-performance
> A context switch storm is when your machine spends more time trying to
> figure out what to do than actually doing anything.  The CPU spends most
> it's time switching between programs than running them.

Well, we usually use the term "thrashing" as the generic for when your
machine is spending more time on overhead than doing user work - this
would include paging or context switching, along with whatever else. A
context-switch storm would be a specific form of thrashing!

Richard

--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
rtroy@ScienceTools.com, http://ScienceTools.com/


pgsql-performance by date:

Previous
From: "Matthew Peters"
Date:
Subject: Re: Stored procedure slower than sql?
Next
From: Richard Troy
Date:
Subject: Re: commit so slow program looks frozen