[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: DB Upgrade complete



On Tue, 2007-07-10 at 10:09 -0500, Mike McGrath wrote:
> Mike Bonnet wrote:
> > On Tue, 2007-07-10 at 09:56 -0500, Mike McGrath wrote:
> >   
> >> With autovacuum on do we still have to run the nightly vacuum jobs?
> >>     
> >
> > We'll have to keep an eye on the heavily-updated tables, but autovacuum
> > combined with the max_fsm_pages increase should remove the need for the
> > nightly vacuums.
> >   
> 
> Sounds good, I'll leave them in the cron.d file but comment them out and 
> mention why.
> 
We probably want to change to a monthly maintenance schedule where we
run a vacuum full on the dbs.

I also noticed that shmmax hasn't been increased from the default
(32MB).  Do we need to do that to match the shared cache buffer (512MB)?

$ /sbin/sysctl  kernel.shmmax
kernel.shmmax = 33554432

-Toshio

Attachment: signature.asc
Description: This is a digitally signed message part


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]