Now it's too late, but maybe you could allow to not use a single transaction ( but instead 127k transactions).4
Then 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. Cheers, Rémi-C 2013/11/26 Joey Quinn <bjquinn...@gmail.com> > 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)? > > >
