Chirag Dave <cdave@ca.afilias.info> writes:
> While testing on 8.3, i see that upon postmaster restart , i am loosing
> data from pg_stat_user_tables.
Hm, I don't see any such behavior here. Are you sure you are shutting
the postmaster down normally? We do throw away stats during a crash
recovery, which would mean that this is expected behavior if you're
in the habit of doing "pg_ctl stop -m immediate". But if you are,
I'd suggest reforming that habit ...
regards, tom lane