Re: This query is still running after 10 hours... - Mailing list 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