Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: NapoleanDate: 2005-08-24 23:43:57
Subject: Recovering Database
Previous:From: Jim C. NasbyDate: 2005-08-24 18:19:23
Subject: Re: Reg:sql command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group