Re: help me to explain database behaviour after vacuum. - Mailing list pgsql-admin

From Tom Lane
Subject Re: help me to explain database behaviour after vacuum.
Date
Msg-id 8335.1124912663@sss.pgh.pa.us
Whole thread Raw
In response to help me to explain database behaviour after vacuum.  (Ivan <Ivan-Sun1@mail.ru>)
List 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 by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Fwd: Indexes (Disk space)
Next
From: "Napolean"
Date:
Subject: Recovering Database