Skip site navigation (1) Skip section navigation (2)

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

From: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
To: Gaetano Mendola <mendola(at)bigfoot(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: This query is still running after 10 hours...
Date: 2004-09-29 02:25:07
Message-ID: 20040928202507.7fbbdb7c@thunder.mshome.net (view raw or flat)
Thread:
Lists: pgsql-performance
When grilled further on (Tue, 28 Sep 2004 16:55:13 +0200),
Gaetano Mendola <mendola(at)bigfoot(dot)com> confessed:

> 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 ?
> 

Gee, the two questions I realized I forgot to answer going into work ;-)  I  run
pg_autovacuum, and it's working.  Even ran a FULL ANALYZE, no help.  The version
is 7.4.1.

Cheers,
Rob 

-- 
 20:22:11 up 5 days, 22:48,  2 users,  load average: 2.16, 2.18, 2.15
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004

In response to

pgsql-performance by date

Next:From: Kevin BarnardDate: 2004-09-29 02:41:50
Subject: Re: This query is still running after 10 hours...
Previous:From: Robert CreagerDate: 2004-09-29 02:21:40
Subject: Re: This query is still running after 10 hours...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group