Re: help me to explain database behaviour after vacuum.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: help me to explain database behaviour after vacuum.
Дата
Msg-id 8335.1124912663@sss.pgh.pa.us
обсуждение исходный текст
Ответ на help me to explain database behaviour after vacuum.  (Ivan <Ivan-Sun1@mail.ru>)
Список pgsql-admin
Ivan <Ivan-Sun1@mail.ru> writes:
> As you can see, disk usage stop grows for several hours
> (3-5) after vacuum, then start again.

You don't have max_fsm_pages set large enough.  Note the output at the
end of the VACUUM printout:

> INFO:  free space map: 67 relations, 20713 pages stored; 29872 total pages needed
> ��������:  Allocated FSM size: 1000 relations + 20000 pages = 186 kB shared memory.

30000 instead of 20000 would be enough at the moment, but I'd suggest
going to 100000 to give yourself some breathing room.

            regards, tom lane

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Fwd: Indexes (Disk space)
Следующее
От: "Napolean"
Дата:
Сообщение: Recovering Database