Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group