On 24/11/05 4:19 pm, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote: > 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 ... Well each of these datasets are about 20,000 rows each... So I can tell which one is in (640792,12) and in (640799,1), they have the same dataset id value. Im assuming the missing ones in the middle will therefore be from the same dataset as well then... So I know which files did not get uploaded properly and I can re-upload them.... Is that what you were referring to? Thanks again Adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
