DB Upgrade complete

[Toshio Kuratomi]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://listman.redhat.com/archives/fedora-infrastructure-list/attachments/20070711/f55eca65/attachment.sig>