On Wed, Nov 23, 2011 at 10:27 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx> writes:
> On Wed, Nov 23, 2011 at 9:01 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
>> No, it's looking at a last-update timestamp field in pg_control.
> So, Is it a approximate time of crash on the basis of last-modifiedIIRC, that's going to be the time of last checkpoint completion on a
> timestamp of pg_control file ?
normally-operating server. So depending on your checkpoint settings,
and how busy the server is, it might or might not be very close to
the time of crash.
regards, tom lane
Perfect. I understood.
Thanks for explaining Tom... :)
