On 24/11/05 2:48 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote: > Adam Witney <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
