lot of empty (zombies?) files in tablespaces

Поиск
Список
Период
Сортировка
От Marc Mamin
Тема lot of empty (zombies?) files in tablespaces
Дата
Msg-id B6F6FD62F2624C4C9916AC0175D56D8828AADEFF@jenmbs01.ad.intershop.net
обсуждение исходный текст
Список 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Gilberto Castillo"
Дата:
Сообщение: Re: how to connect pgadmin III to postgresql 9.1.3 in ubuntu local computer?
Следующее
От: Iñigo Salvat
Дата:
Сообщение: Re: how to connect pgadmin III to postgresql 9.1.3 in ubuntu local computer?