Now it's too late,
but maybe you could allow to not use a single transaction ( but instead 127k transactions).4Then at the end of every transaction you could print something in gui (print for pgscript, raise for plpgsql) or execute a command to write in a file (copy for instance).
It would also be in the log, but not so clear.
Rémi-C
2013/11/26 Joey Quinn <bjquinniii@xxxxxxxxx>
I have a fairly large table (4.3 billion rows) that I am running an update script on (a bit over 127 thousand individual update queries). I am using the gui. It has been running for about 24 hours now. Is there any good way to gauge progress (as in, how many of the individual update queries have finished)?
