Re: tracking scripts...
| От | Rémi Cura |
|---|---|
| Тема | Re: tracking scripts... |
| Дата | |
| Msg-id | CAJvUf_uRct3-4UpZid4WDkU5kFq-oGBDqrK_cm+ueszQY6wMog@mail.gmail.com обсуждение исходный текст |
| Ответ на | tracking scripts... (Joey Quinn <bjquinniii@gmail.com>) |
| Ответы |
Re: tracking scripts...
|
| Список | pgsql-general |
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@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)?
В списке pgsql-general по дате отправления: