select ip,round((select sum(t1.size) from table t1)) 
from table 
where date > '2011.07.29' 
and date < '2011.07.30' 
and ip = '255.255.255.255' 
group by ip;

当我运行此查询时,我收到此错误：

ERROR:  could not read block 4707 of relation 1663/16384/16564: Success

但是这个查询工作正常：

select ip,round(sum(size)/175) 
from table 
where date > '2011.07.29' 
and l_date < '2011.07.30' 
and ip = '255.255.255.255' 
group by ip;

我认为这可能是一个数据库错误,我需要从备份恢复表,也许.但首先我需要了解这些损坏的数据存在的位置.有谁知道如何找到1663/16384/16564关系？还是4707块？

编辑：
我试过这段代码：

select relname,relfilenode from pg_class where  relname in ('1663','16384','16564');

但它返回：

relname | relfilenode 
---------+-------------
(0 rows)