DB Upgrade complete

[Mike McGrath]

Mike Bonnet wrote:
> On Wed, 2007-07-11 at 18:09 -0400, Toshio Kuratomi wrote:
>   
>> 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.
>>     
>
> 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 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.
>   

I'm going to try to get these changes into the db tonight.

    -Mike