[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] lot of empty (zombies?) files in tablespaces
From:       Marc Mamin <M.Mamin () intershop ! de>
Date:       2014-07-15 15:12:19
Message-ID: B6F6FD62F2624C4C9916AC0175D56D8828AADEFF () jenmbs01 ! ad ! intershop ! net
[Download RAW message or body]

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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
[prev in list] [next in list] [prev in thread] [next in thread]