Re: Long update progress

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
Thread:
Lists: pgsql-adminpgsql-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/

In response to

Responses

Browse pgsql-admin by date

  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

Browse pgsql-general by date

  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