Re: Autovaccum failure with Postgres 8.3.14? (max-fsm_pages issue?) - Mailing list pgsql-admin

From subhasis.bhattacharya@gmail.com
Subject Re: Autovaccum failure with Postgres 8.3.14? (max-fsm_pages issue?)
Date
Msg-id 452724770-1354079116-cardhu_decombobulator_blackberry.rim.net-51040471-@b13.c20.bise7.blackberry
Whole thread Raw
In response to Autovaccum failure with Postgres 8.3.14? (max-fsm_pages issue?)  (Subhasis Bhattacharya <subhasis.bhattacharya@gmail.com>)
List pgsql-admin
Hi Scott,

Thanks for ur reply. BTW I thought 8.3.14 was the latest in the 8.3 series...no?


------Original Message------
From: Scott Marlowe
To: Subhasis Bhattacharya
Cc: Craig Ringer
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Autovaccum failure with Postgres 8.3.14? (max-fsm_pages issue?)
Sent: Nov 28, 2012 4:55 AM

On Sat, Nov 24, 2012 at 7:25 AM, Subhasis Bhattacharya
<subhasis.bhattacharya@gmail.com> wrote:
> Thanks Craig,
>
> We have plans to upgrade to a later version of postgres, but that could take
> a while.
>
> Meantime, I wanted to understand whether the autovacuum failure could be
> linked to the fact that the stats collector could not update (rename) the
> pgstats file?

It's important to understand that Craig is implying you're getting
bitten by a bug in an early version of pg 8.3 that can be fixed by
updating to a later version of pg 8.3.  Updating within a minor
version number like that causes minimum down time as it simply copies
in new binary files and restarts the db with no need for upgrading the
/data directory.  On most debian based boxes it's as simple as:

sudo apt-get update
or
sudo apt-get upgrade


Sent from BlackBerry® on Airtel

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Autovaccum failure with Postgres 8.3.14? (max-fsm_pages issue?)
Next
From: subhasis.bhattacharya@gmail.com
Date:
Subject: Re: Autovaccum failure with Postgres 8.3.14? (max-fsm_pages issue?)