There is no simple utility program or function that you can run to figure out which tables are affected by database corruption. You have to do a deep analysis. You try running a command like: > showdb $YOURDATABASE pgidx To get an idea of which each page in the file is used for. But badly corrupted pages might not show up in the output, as that utility is not able to trace them back to their use. Using the "showdb" utility, you can dump the content of page 3282. I'm guessing you will find that it has been zeroed out by your hardware. To get the "showdb" utility program, download the source code and run "make showdb".