Postgres Pro
Downloads
Home   >   mailing lists

Re: Query is taking 5 HOURS to Complete on 8.1 version - Mailing list pgsql-performance

From smiley2211
Subject Re: Query is taking 5 HOURS to Complete on 8.1 version
Date
Msg-id 11419885.post@talk.nabble.com
Whole thread Raw
In response to Query is taking 5 HOURS to Complete on 8.1 version  (smiley2211 <smiley2211@yahoo.com>)
Responses Re: Query is taking 5 HOURS to Complete on 8.1 version
List pgsql-performance
Tree view 
TOP shows CPU at 100% while executed the EXPLAIN ANALYZE...what does this
mean?

17519 postgres  25   0 3470m  43m  39m R  100  0.3  28:50.53 postmaster
--
View this message in context:
http://www.nabble.com/Query-is-taking-5-HOURS-to-Complete-on-8.1-version-tf4019778.html#a11419885
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

pgsql-performance by date:

Previous
From: "Chris Hoover"
Date:
Subject: Re: Query is taking 5 HOURS to Complete on 8.1 version
Next
From: Richard Huxton
Date:
Subject: Re: Query is taking 5 HOURS to Complete on 8.1 version