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, 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general