Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.4.1 upgrade issues - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.4.1 upgrade issues
Date
Msg-id 20441.1078632931@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.4.1 upgrade issues  ("Gavin M. Roy" <gmr@ehpg.net>)
Responses Re: 7.4.1 upgrade issues
List pgsql-general
Tree view 
"Gavin M. Roy" <gmr@ehpg.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

pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Changing schema owner?
Next
From: "Gavin M. Roy"
Date:
Subject: Re: 7.4.1 upgrade issues