Many thanks Scott..
------Original Message------
From: Scott Marlowe
To: subhasis.bhattacharya@gmail.com
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 10:38 AM
latest is 8.3.21 according to postgresql.org.
On Tue, Nov 27, 2012 at 10:05 PM, <subhasis.bhattacharya@gmail.com> wrote:
> 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
--
To understand recursion, one must first understand recursion.
Sent from BlackBerry® on Airtel