DB Upgrade complete
Toshio Kuratomi
a.badger at gmail.com
Wed Jul 11 22:41:32 UTC 2007
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>
More information about the Fedora-infrastructure-list
mailing list