Re: This query is still running after 10 hours...

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
Subject: Re: This query is still running after 10 hours...
Date: 2004-09-28 14:55:13
Message-ID: 41597B51.7040100@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Robert Creager wrote:
> Help?
>
> Normally, this query takes from 5 minutes to 2 hours to run. On this update, it's been running for more than 10 hours.
>
> Can it be helped?

When I see this usually means that tables are full of
dead rows. Did you vacuum you DB. Which version are you
using ?

Regards
Gaetano Mendola

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-09-28 15:04:23 Re: This query is still running after 10 hours...
Previous Message Aaron Werman 2004-09-28 14:36:03 Re: Caching of Queries