8.1beta3 performance - Mailing list pgsql-performance

From PostgreSQL
Subject 8.1beta3 performance
Date
Msg-id dk68ku$2lqa$1@news.hub.org
Whole thread Raw
Responses Re: 8.1beta3 performance  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Re: 8.1beta3 performance  (Neil Conway <neilc@samurai.com>)
Re: 8.1beta3 performance  (Jon Brisbin <jon.brisbin@npcinternational.com>)
List pgsql-performance
We're running 8.1beta3 on one server and are having ridiculous performance
issues.  This is a 2 cpu Opteron box and both processors are staying at 98
or 99% utilization processing not-that-complex queries.  Prior to the
upgrade, our I/O wait time was about 60% and cpu utilization rarely got very
high, now I/O wait time is at or near zero.

I'm planning to go back to 8.0 tonight or tomorrow night but thought I'd
check the pqsql-performance prophets before I gave it up.



pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.x index insert performance
Next
From: mark@mark.mielke.cc
Date:
Subject: Re: 8.x index insert performance