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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general