El 26/12/17 a las 09:52, Edson Carlos Ericksson Richter escribió: > Recently I had a problem with a base file with size 0 in a standby server. > > This raised one question: does PostgreSQL (9.6.6) check base integrity > at startup? > > At least if there are 0 byte size files in base dir? Or CRC? Something?
Yes it has CRC check, but only if you initialize the cluster with --data-checksums, and there's a price to pay in performance.
It has CRC check, but it is used in runtime - when data are necessary
So Postgres usually check nothing on start - few system tables and indexes
