Ivan <Ivan-Sun1(at)mail(dot)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
In response to
pgsql-admin by date
|Next:||From: Napolean||Date: 2005-08-24 23:43:57|
|Subject: Recovering Database|
|Previous:||From: Jim C. Nasby||Date: 2005-08-24 18:19:23|
|Subject: Re: Reg:sql command|