roctaiwan <nettreeinc at gmail.com> writes:
> By doing the clustering, I am trying to find out status such as how many
> records got updated, and time that it started and finished update. 
>
> Does anyone know where I can find log that will give me these informations?
> or a tool that can college those infos for me?
>
> I have enabled useful pramaters under "runtime statistic" in
> postgresql.conf. But I don't know where to find infomation that I need. 

Starting in 1.2, we started reporting numbers of inserts/updates/deletes
in the slon logs; look for lines looking like:

   "remoteHelperThread_%d_%d: inserts=%d updates=%d deletes=%d\n",

In 1.2, this is reported at debug level SLON_DEBUG2.

In 2.0, this is reported at debug level SLON_DEBUG1.

See the slon log output; that will be stored whereever you choose to
store it.
-- 
let name="cbbrowne" and tld="ca.afilias.info" in String.concat "@" [name;tld];;
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"