On 24/11/05 2:48 pm, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote: > Adam Witney <awitney@xxxxxxxxxx> writes: >> Just wanted to clarify, should this not be >> dd bs=8k seek=73333 count=1 conv=notrunc if=/dev/zero of=134401991.4 > > Looks reasonable. > > regards, tom lane Excellent thanks. I have run it and copied the changed file back into the right place and run vacuum: bugasbase2=# vacuum; WARNING: relation "mba_data_base" page 597621 is uninitialized --- fixing WARNING: relation "mba_data_base" page 640793 is uninitialized --- fixing WARNING: relation "mba_data_base" page 640794 is uninitialized --- fixing WARNING: relation "mba_data_base" page 640795 is uninitialized --- fixing WARNING: relation "mba_data_base" page 640796 is uninitialized --- fixing WARNING: relation "mba_data_base" page 640797 is uninitialized --- fixing WARNING: relation "mba_data_base" page 640798 is uninitialized --- fixing VACUUM Does this look reasonable? Or should I be looking for other problems? There are some different pages being fixed here from the ones that were shown before (597621), they all belong to a different dataset so looks like I have to reupload that one as well. Thanks again for your help Adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
