huge pgstat.stat file on PostgreSQL 8.3.24

From: "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: huge pgstat.stat file on PostgreSQL 8.3.24
Date: 2014-06-19 04:38:54
Message-ID: D83E55F5F4D99B4A9B4C4E259E6227CD014A1351@AUX1EXC01.apac.experian.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi group,

We've found huge pgstat.stat file on our production DB boxes, the size is over 100MB. autovacuum is enabled. So my question would be:

1. What's a reasonable size of pgstat.stat file, can it be estimated?

2. What's the safest way to reduce the file size to alleviate the IO impact on disk?

3. If need to drop all statistics, would a "analyze DB" command enough to eliminate the performance impact on queries?

Thanks,
Suya

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pavel Stehule 2014-06-19 05:28:16 Re: huge pgstat.stat file on PostgreSQL 8.3.24
Previous Message Tom Lane 2014-06-18 19:37:27 Re: Unable to allocate 2G of shared memory on wheezy