Search Postgresql Archives

Re: Long running update

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



# akash.garg@xxxxxxxxx / 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux