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

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