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
