Ivan <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to