>> Descobrir a tabela relacionada:
SELECT relname FROM pg_class WHERE relfilenode = 20674;
resultado : vazio
>> Descobrir os arquivos no disco:
SELECT oid,ctid,cmin,cmax,relname,
relfilenode,pg_relation_filepath(oid)
FROM pg_class WHERE relname ~ 'pg_toast_20670';
resultado:
oid ctid cmin cmax relname relfilenode pg_relation_filepath 20673
-43,11 5 5 pg_toast_20670 2095406497 base/16385/2095406497 20675 -43,12 5 5
pg_toast_20670_index 2095406499 base/16385/2095406499 20673 -108,39 5 5
pg_toast_20670 2101671235 base/16385/2095406497 20675 -109,3 5 5
pg_toast_20670_index 2101671237 base/16385/2095406499
-- Procurando os arquivos:
root@condor:/dbprod/data/base/16385# find / -name 2095406497
/dbprod/data/base/16385/2095406497
root@condor:/dbprod/data/base/16385# find / -name 2095406499
/dbprod/data/base/16385/2095406499
-- Verificando tamanho e data dos arquivos :
root@condor:/dbprod/data/base/16385# ls -lh 2095406497
-rw------- 1 postgres postgres 0 Nov 5 01:42 2095406497
root@condor:/dbprod/data/base/16385# ls -lh 2095406499
-rw------- 1 postgres postgres 0 Nov 5 01:42 2095406499
Posso apagá-los?
estão vazios e com data do dia 05/11/2013.
Por que será?
Att,
Deliane Andrade
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
