From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: PostgreSQL <martin@portant.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: 8.1beta3 performance
Date: Tue, 1 Nov 2005 03:00:26 +0100
Message-ID: <20051101020026.GA4707@uio.no> (raw)
In-Reply-To: <dk68ku$2lqa$1@news.hub.org>
References: <dk68ku$2lqa$1@news.hub.org>
On Mon, Oct 31, 2005 at 05:16:46PM -0600, PostgreSQL wrote:
> 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.
It sounds like some query got planned a different way that happened to be
really suboptimal -- I've seen really bad queries be quick on earlier
versions "by accident" and then not have the same luck on later versions.
Could you find out what queries are taking so long (use
log_min_duration_statement), and post table definitions and EXPLAIN ANALYZE
output here?
/* Steinar */
--
Homepage: http://www.sesse.net/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sgunderson@bigfoot.com, martin@portant.com
Subject: Re: 8.1beta3 performance
In-Reply-To: <20051101020026.GA4707@uio.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox