Dear All,
The stats file in *pg_stat_tmp *are getting corrupted. Even earlier the
files in *pg_stat* got corrupted. They show ?? ?? when you list the files
in folder. Also we can see them in the error log.
it says " *could not open statistics file 'pg_stat_tml/db_0.tmp': to
'pg_stat_tmp/db_0.stat': Input/output error".*
After doing e2fsck (file system scan ) it is fixed but that needs downtime
and also it removes the file. What is the impact if the file is being
removed ?
Has anybody faced such issue or can guide me what can be done and how it
can be avoided in near future ?
Thanks and Regards,
Devendra Yadav