Konrad Garus <konrad(dot)garus(at)gmail(dot)com> writes:
> 2010/1/8 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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