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

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: This query is still running after 10 hours...
Дата
Msg-id 41597B51.7040100@bigfoot.com
обсуждение исходный текст
Ответ на This query is still running after 10 hours...  (Robert Creager <Robert_Creager@LogicalChaos.org>)
Ответы Re: This query is still running after 10 hours...  (Robert Creager <Robert_Creager@LogicalChaos.org>)
Список 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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: This query is still running after 10 hours...
Следующее
От: Josh Berkus
Дата:
Сообщение: Interest in perf testing?