Wierd performance issue with 8.1cvs - Mailing list pgsql-hackers

From Josh Berkus
Subject Wierd performance issue with 8.1cvs
Date
Msg-id 200504201109.19704.josh@agliodbs.com
Whole thread Raw
Responses Re: Wierd performance issue with 8.1cvs  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: Wierd performance issue with 8.1cvs  (Greg Stark <gsstark@mit.edu>)
Re: Wierd performance issue with 8.1cvs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Folks,

At OSDL we're seeing a wierd performance crash on 8.1cvs.   What's wierd about 
it is that it doesn't happen all the time -- about 1 out of 4 test runs.    
What it looks like happens sometimes is that performance drops dramatically 
at the first checkpoint, and never comes back.  But there's oprofiles and 
things to make a more insightful analysis:

3 test runs exhibit it:
http://khack.osdl.org/stp/301531/0.html
http://khack.osdl.org/stp/301736/0.html
http://khack.osdl.org/stp/301730/0.html

Note that these are all different day's builds.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Problem with PITR recovery
Next
From: Alvaro Herrera
Date:
Subject: Re: Wierd performance issue with 8.1cvs