Wierd performance issue with 8.1cvs

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Wierd performance issue with 8.1cvs
Date: 2005-04-20 18:09:19
Message-ID: 200504201109.19704.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2005-04-20 18:31:11 Re: Wierd performance issue with 8.1cvs
Previous Message Josh Berkus 2005-04-20 17:59:01 Re: Bad n_distinct estimation; hacks suggested?