Re: Long running update

Поиск
Список
Период
Сортировка
От Roman Neuhauser
Тема Re: Long running update
Дата
Msg-id 20050811233206.GA24601@isis.sigpipe.cz
обсуждение исходный текст
Ответ на Long running update  (Akash Garg <akash.garg@gmail.com>)
Ответы Re: Long running update  (Greg Stark <gsstark@mit.edu>)
Список pgsql-general
# akash.garg@gmail.com / 2005-08-11 16:17:09 -0700:
> Hello,
> I currently running an update statement that updates every row in a
> very large table.  This query will obviously take a long time to run.
> My question -- is there any way to know how much time it will take
> once it starts?  Even something that could help me approximate the
> speed at which it's doing the update would be helpful.

    Yeah, it would be nice if select, insert, update, delete could
    be set to log their progress at configured intervals.

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991

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

Предыдущее
От: Akash Garg
Дата:
Сообщение: Long running update
Следующее
От: CSN
Дата:
Сообщение: Re: plphp: PHP Warning: Call-time pass-by-reference has been deprecated