Re: Tracking progress of (plpgsql?) operations

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: k992637(at)yahoo(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Tracking progress of (plpgsql?) operations
Date: 2006-05-03 13:44:09
Message-ID: 20060503134409.GB29954@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sun, Apr 30, 2006 at 16:36:04 -0700,
k992637(at)yahoo(dot)com wrote:
> as I can tell) see the intermediate stage of processing. What I would
> ideally like is to be able to update a log table which stored how many
> values of A were selected and how many values of A have finished
> calculating, updating this every 5 iterations or so. However I will
> never see an intermediate state in this table due to transactions (is
> this correct?).

If you use a trusted PL language, you can write to files which will probably
allow you to do what you want.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2006-05-03 13:44:38 Re: Snapshot Copy of a Postgres DB
Previous Message Bruno Wolff III 2006-05-03 13:40:18 Re: Forgotten Password