"Qingqing Zhou" <zhouqq@xxxxxxxxxxxxxx> writes: > Actually I tried to simulate your situation, but everytime I got a neat > recovery -- You probably filled the test table and then vacuumed within a single checkpoint cycle, so that the replay sequence included loading data into page 1 in the first place. The risk case is fill table, checkpoint, vacuum, crash; because then the replay starts from the checkpoint and won't re-create page 1. regards, tom lane