| From: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de> |
|---|---|
| To: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | lot of empty (zombies?) files in tablespaces |
| Date: | 2014-07-15 15:12:19 |
| Message-ID: | B6F6FD62F2624C4C9916AC0175D56D8828AADEFF@jenmbs01.ad.intershop.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gilberto Castillo | 2014-07-15 15:56:27 | Re: how to connect pgadmin III to postgresql 9.1.3 in ubuntu local computer? |
| Previous Message | David G Johnston | 2014-07-15 14:48:36 | Re: how to connect pgadmin III to postgresql 9.1.3 in ubuntu local computer? |