Re: tracking scripts...

The queries themselves are written like so:

update ipv4_table set country='xx' where ipv4 between 'xxx.xxx.xxx.xxx' and
'xxx.xxx.xxx.xxx';

There are 127k lines like that (each with a different range and the
appropriate country code). Each is terminated with a semi-colon. Does that
make them individual transactions in postgres or not? (postgres newbie
here). Is there something else I need to do for them to be treated like
separate transactions?

On Tue, Nov 26, 2013 at 11:16 AM, Rémi Cura <remi(dot)cura(at)gmail(dot)com> wrote:

> 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 <bjquinniii(at)gmail(dot)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)?
>>
>>
>>
>