Re: memory bug

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: memory bug
Дата
Msg-id 87oev1sp6b.fsf@mailbox.samurai.com
обсуждение исходный текст
Ответ на memory bug  ("Alex Albarracin" <aalbarracin@corest.com>)
Список pgsql-bugs
"Alex Albarracin" <aalbarracin@corest.com> writes:
> Hello, i have a problem related to the partition memory where
> postgres is installed, this has increased so much that the partition
> is full and postgres can not start up. The message postmaster sends
> when i want to restart is insuficient disk space. Do you know if
> postgres uses some disk space that may not releases.

Unused disk space is released by VACUUM FULL. If I understand your
situation correctly, I'd recommend temporarily adding some more disk
space or moving some data to another partition to allow the postmaster
to startup. Then you can reclaim some disk space using VACUUM FULL
and/or REINDEX. In the future, run VACUUM more frequently (and perhaps
bump max_fsm_pages).

-Neil

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 7.4: FATAL: unrecognized configuration parameter "show_statement_stats"
Следующее
От: Seum-Lim Gan
Дата:
Сообщение: Fwd: Solaris build of 7.4 problem with --enable-thread-safety