Re: [GENERAL] 7.4.1 upgrade issues

[Gavin M. Roy]

I'll post it if you want, but the issue isn't with the optimizer, index 
usage, or seq scan, the issue seems to be more revolving around the 
backend getting so much cpu priority it's not allowing other backends to 
process, or something along those lines.   For the hardware question 
asked, it's an adaptec 7899 Ultra 160 SCSI card w/ accompanying fast 
drives...

Again, I'll send the explain, etc if you think it would help answer my 
question, but from my perspective, the amount of time the query takes to 
execute isnt my issue, but the fact that nothing else can seemingly 
execute while its running.

Gavin

Tom Lane wrote:

"Gavin M. Roy" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html
 



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings