From: | <mallah(at)trade-india(dot)com> |
---|---|
To: | <amarden(at)usa(dot)net> |
Cc: | <pgsql-admin(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Long update progress |
Date: | 2002-07-19 12:46:38 |
Message-ID: | 62064.203.196.129.235.1027082798.squirrel@mail.trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
create a sequence and somehow involve it in a dummy manner in the update...
do a select current_val('sequence') to see how far updates have gone...
can we see the update stmt?
regds
mallah.
> We have an database batch update process running. It runs normally and
> takes around 6 hours. This is dealing with a much larger data set after
> an error correction. It's been running for 6 days now and people are
> getting twitchy that it might not finish. Is there any way (accepting
> that more preparation would, in retrospect, have been better) to tell
> how far we're got. This iterates round a cursor and updates individual
> rows. The trouble is it commits once at the end.
>
> The ideal would be to find a way of doing a dirty read against the
> table that is bing updated. Then we'd know how many rows had been
> processed.
>
> Any ideas?
>
> Cheers
>
> Andy
>
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 5: Have you checked our
> extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Marden | 2002-07-19 12:52:27 | Re: Long update progress |
Previous Message | Jan D'Hondt | 2002-07-19 12:43:23 | Re: Disabling case sensitivity |
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Marden | 2002-07-19 12:52:27 | Re: Long update progress |
Previous Message | Steve Brett | 2002-07-19 12:46:36 | Re: References for PostgreSQL |