Kynn Jones wrote:
(Sorry for asking so many questions!)
What techniques can one use to monitor the progress of a stored
procedure?
Specifically, how can I get the procedure to print a progress
indicator message to the screen every once in a while?
[...](In case it matters, the procedure is written in PL/perl. I
tried to use Perl's print statement, unbuffered, to print out a
message periodically from within the procedure, but I see no output.)
elog? (see example in
http://www.postgresql.org/docs/8.3/interactive/plperl-database.html)
klint.
--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350
Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@xxxxxxxxxx
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
