Re: 8.1beta3 performance

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: PostgreSQL <martin(at)portant(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 8.1beta3 performance
Date: 2005-11-01 02:00:26
Message-ID: 20051101020026.GA4707@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Neil Conway 2005-11-01 02:06:15 Re: 8.1beta3 performance
Previous Message mark 2005-10-31 23:57:09 Re: 8.x index insert performance