Adam Witney <awitney@xxxxxxxxxx> writes: > If you mean by that, this: > select * from mba_data_base where ctid = '(640792,12)'; > select * from mba_data_base where ctid = '(640799,1)'; > Then the data looks normal... Of course everything in between that is now > blank. The question is, can you tell whether any data is actually missing? In the crash scenario I was describing, no committed data would be lost. If these blocks went zero because of filesystem misfeasance, however, you might have lost data ... regards, tom lane
