lot of empty (zombies?) files in tablespaces

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,

(Postgres 9.3.4/Linux)

we have about 15 % of the files in our tablespaces that are empty 
and do not appear in "select pg_relation_filepath(oid) from pg_class".

My guess is that a lot of them are the result of vacuuming full around 50'000 tables out of 150'000.
Is there a known issue that can explain this ?

We have an unusual configuration where the tablespaces are located within $PGDATA,
either directly or as symbolic link...

- Is there a proof mean to identify all files that are still required
- A way to  clean such zombies files ?


regards,

Marc Mamin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux