Konrad Garus <konrad.garus@gmail.com> writes:
> 2010/1/8 Tom Lane <tgl@sss.pgh.pa.us>:
>> Do you know that the rows disappeared recently?
> Yes. They are present in dump from 9 PM and missing from dump from 1
> AM. It must've happened within this 4-hour window.
Hm. It would be interesting to see if you can find the place where the
rows had been and dump it with pg_filedump
http://sources.redhat.com/rhdb/
You can look at the ctid column of the rows that are adjacent to the
missing ones according to your older dump, and then dump out those
blocks (I recommend -i -f style).
regards, tom lane