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

Re: DB Upgrade complete



On Wed, 2007-07-11 at 18:19 -0400, Mike Bonnet wrote:

> If things are configured correctly, postgres 8.1 should never require a
> full vacuum.  Dead tuples get garbage-collected by the auto-vacuum
> process and the space is reused for new tuples.  I'd rather avoid a
> window where all access to tables is locked out by the vacuum full.
> 
I thought autovacuum wasn't able to take care of the update table case
but it appears I was wrong.  Great!

> > 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
> 
> Yes, there's a note about that in the diff.  It needs to get changed or
> postgresql won't start with the modified config.
> 
Doh!  Apparently my parser needs to be trained not to skip comments :-)

-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]