Siddharth Shah <siddharth.shah@xxxxxxxxxxxxx> writes: > I have found pgstat.stat file taking too much write hits. > As my need to deploy on flash based storage. I don't want higher I/O's > To stop status collector process I have change postmaster.c by removing > calls of pgstat.c > Now every thing is working fine, Status collector process is not initiated ? > Any drawbacks for not writing pgstat.stat ? Autovacuum doesn't work ... If you are willing to run a hand-hacked version then I'd suggest doing your experimentation with CVS HEAD. There are changes in place already to reduce the stats file traffic. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general