Re: lossing pg_stat's data - Mailing list pgsql-general

From Tom Lane
Subject Re: lossing pg_stat's data
Date
Msg-id 21169.1218081057@sss.pgh.pa.us
Whole thread Raw
In response to lossing pg_stat's data  (Chirag Dave <cdave@ca.afilias.info>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Create Table Dinamic
Next
From: "Merlin Moncure"
Date:
Subject: Re: bytea encode performance issues