Re: Long running update - Mailing list pgsql-general

From Roman Neuhauser
Subject Re: Long running update
Date
Msg-id 20050811233206.GA24601@isis.sigpipe.cz
Whole thread Raw
In response to Long running update  (Akash Garg <akash.garg@gmail.com>)
Responses Re: Long running update  (Greg Stark <gsstark@mit.edu>)
List 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 by date:

Previous
From: Akash Garg
Date:
Subject: Long running update
Next
From: CSN
Date:
Subject: Re: plphp: PHP Warning: Call-time pass-by-reference has been deprecated