Re: leaking lots of unreferenced inodes (pg_xlog files?), maybe after moving tables and indexes to tablespace on different volume
В списке pgsql-hackers по дате отправления:
| От | Tom Lane |
|---|---|
| Тема | Re: leaking lots of unreferenced inodes (pg_xlog files?), maybe after moving tables and indexes to tablespace on different volume |
| Дата | |
| Msg-id | 10115.1363140236@sss.pgh.pa.us обсуждение |
| Ответ на | leaking lots of unreferenced inodes (pg_xlog files?), maybe after moving tables and indexes to tablespace on different volume (Palle Girgensohn <girgen@FreeBSD.org>) |
| Ответы |
Re: leaking lots of unreferenced inodes (pg_xlog files?),
maybe after moving tables and indexes to tablespace on different volume
|
| Список | pgsql-hackers |
Palle Girgensohn <girgen@FreeBSD.org> writes:
> ... I got lots of space freed
> up, but it seems that after that the disk usage grows linearly (it seems
> to leave many inodes unreferenced).
Hm. We've seen issues in the past with PG processes failing to close
no-longer-useful files promptly, but ...
> Strange thing is I cannot find any open files.
... that suggests there's something else going on.
> The unreferenced inodes are almost exclusively around 16 MB in size, so
> i.e. they would most probably all be pg_xlog files.
Have you got any sort of WAL archiving active, and if so maybe that's
holding onto WAL files? Not that it's clear how come lsof wouldn't
tattle on an archiving process either.
> Stopping postgresql briefly did not help, I tried that.
That seems to point the finger at some non-postgres cause. I confess
I can't guess what.
regards, tom lane
В списке pgsql-hackers по дате отправления:
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера