Re: Query is taking 5 HOURS to Complete on 8.1 version

From: smiley2211 <smiley2211(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query is taking 5 HOURS to Complete on 8.1 version
Date: 2007-07-03 20:18:38
Message-ID: 11419885.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2007-07-03 20:27:01 Re: Query is taking 5 HOURS to Complete on 8.1 version
Previous Message Chris Hoover 2007-07-03 20:16:50 Re: Query is taking 5 HOURS to Complete on 8.1 version