Re: help me to explain database behaviour after vacuum.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ivan <Ivan-Sun1(at)mail(dot)ru>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: help me to explain database behaviour after vacuum.
Date: 2005-08-24 19:44:23
Message-ID: 8335.1124912663@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Napolean 2005-08-24 23:43:57 Recovering Database
Previous Message Jim C. Nasby 2005-08-24 18:19:23 Re: Reg:sql command