Re: 7.4.1 upgrade issues

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gavin M(dot) Roy" <gmr(at)ehpg(dot)net>
Cc: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: 7.4.1 upgrade issues
Date: 2004-03-07 04:15:31
Message-ID: 20441.1078632931@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Gavin M. Roy" <gmr(at)ehpg(dot)net> writes:
> It's not WAITING, the larger queries are eating cpu (99%) and the rest
> are running so slow it would seem they're waitng for processing time.

Could we see EXPLAIN ANALYZE output for the large query? (Also the
usual supporting evidence, ie table schemas for all the tables
involved.)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gavin M. Roy 2004-03-07 05:32:57 Re: 7.4.1 upgrade issues
Previous Message Jim Wilson 2004-03-07 00:12:55 Re: 7.4.1 upgrade issues