Status of the startup process post end of recovery

Hello,

While doing some tests, I observed that the "ps" command continues to
display status of the startup process as "recovering <filename>" even
though it has finished the redo and is now performing end-of-recovery
checkpoint. This checkpoint can take a while, a few seconds to a few
minutes depending on the dirty buffers at the end of the recovery. The
"ps" command keep displaying a stale status for all that time. How
about calling set_ps_display() with appropriate status string, say
similar to what is logged by LogCheckpointStart() ? If we do that,
what would be the best place to add that code ? I was thinking adding
that to CreateCheckpoint() itself so that the status is displayed at
all relevant places.

Comments ?

Thanks,
Pavan

--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee