Chirag Dave <cdave@xxxxxxxxxxxxxxx> 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
