From: | Klint Gore <kgore4(at)une(dot)edu(dot)au> |
---|---|
To: | Kynn Jones <kynnjo(at)gmail(dot)com> |
Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to monitor the progress of a stored procedure? |
Date: | 2008-02-28 00:12:18 |
Message-ID: | 47C5FC62.5050008@une.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)une(dot)edu(dot)au
From | Date | Subject | |
---|---|---|---|
Next Message | Gevik Babakhani | 2008-02-28 00:29:43 | Re: Can't start Postgres anymore |
Previous Message | Simon Riggs | 2008-02-28 00:07:29 | PostgreSQL UK 2008 Conference |