pgsql upgrade

From: Matt Chambers <chambers(at)imageworks(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: pgsql upgrade
Date: 2006-12-04 21:58:38
Message-ID: 45749A0E.3010707@imageworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi all, I've run into an issue with a Pg 7.4.6 to 8.1.5 upgrade along
with hardware upgrade.
I moved the database from a 2x 3.0ghz Xeon (512kb w/HT) to a 2x Opteron
250. The database is in
memory on a tmpfs partition. (the application can rebuild the db during
total system failure)

When I first switched it over, the results were exactly what I expected.
I was sustaining about
a 2.2 on the Xeon and with the Opteron, about a 1.5 with the same
traffic. The box is highload,
it ouputs about 15mbps.

After a couple hours working perfectly the ' system' (vs user) load
jumped from
a 3% of total CPU usage, to 30%, a 10x increase, and postgres started to
write out
to data/base at a fairly fast rate. The CPU context switch rate doubled
at the same time.
Iowait, which was historically 0 on the 7.4 box, went to 0.08.

Strangely enough, a vacuum (not full or analyze) stopped postgres from
writing to data/base
but the strange load pattern remains. (system is ~30% of the overall
load, vs 3% before)

So, my question is, what happened, and how can I get it back to the same
load pattern
7.4.6 had, and the same pattern I had for 4 hours before it went crazy?

Matt

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Cramer 2006-12-04 23:28:57 Re: Configuration settings for 32GB RAM server
Previous Message Scott Marlowe 2006-12-04 19:23:04 Re: Configuration settings for 32GB RAM server