Re: [GENERAL] lossing pg_stat's data

Chirag Dave <[EMAIL PROTECTED]> 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,

[GENERAL] lossing pg_stat's data

While testing on 8.3, i see that upon postmaster restart , i am loosing data from pg_stat_user_tables. as i understand in 8.3 only way to reset is by calling |pg_stat_reset(). Sorry for the long post: Here is my test case: sample=# SELECT version();