I'm maintaining an old PostgreSQL-based application (PostgreSQL 9.1.22) on a Windows 2012 Server and we have noticed some data integrity inconsistencies. No errors have been spotted in logs nor in the event viewer, but we have noticed that somebody (or Windows itself) has automatically set the "Compress contents to save disk space" option to the cluster directory (and its subdirectories). I understand that this option works at OS level so it shouldn't affect PostgreSQL (beyond some performance issues), but maybe I'm wrong. Does anybody know if this option might lead to data integrity issues?
Thank you.
After a week with "Compress contents to save disk space" option disabled, I can confirm that this option causes data integrity problems with PostgreSQL engine 9.1.22 on Windows 2012 Server. So my advice is disabling it from the entire cluster directory and subdirectories.