Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tbswi-0002NK-Se for pgsql-admin@postgresql.org; Fri, 23 Nov 2012 13:05:29 +0000 Received: from outmail148093.authsmtp.net ([62.13.148.93]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tbswh-0000d1-4n for pgsql-admin@postgresql.org; Fri, 23 Nov 2012 13:05:28 +0000 Received: from mail-c232.authsmtp.com (mail-c232.authsmtp.com [62.13.128.232]) by punt14.authsmtp.com (8.14.2/8.14.2/) with ESMTP id qAND5OWa077557; Fri, 23 Nov 2012 13:05:24 GMT Received: from ayaki.localdomain (58-7-191-252.dyn.iinet.net.au [58.7.191.252]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/) with ESMTP id qAND5Hfr055429 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO); Fri, 23 Nov 2012 13:05:20 GMT Message-ID: <50AF748C.1090805@2ndQuadrant.com> Date: Fri, 23 Nov 2012 21:05:16 +0800 From: Craig Ringer Organization: 2nd Quadrant User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20121029 Thunderbird/16.0.2 MIME-Version: 1.0 To: Subhasis Bhattacharya CC: pgsql-admin@postgresql.org Subject: Re: Autovaccum failure with Postgres 8.3.14? (max-fsm_pages issue?) References: In-Reply-To: X-Enigmail-Version: 1.4.5 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Server-Quench: 6fbb61c4-356e-11e2-b10b-0025903375e2 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZeVg0b BQteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagZbY1ZH HGQLWlZEUV57WWZ/ aQsfaA1DZVRPVgR0 Uk1LXVBXFgB3AFJA d2BqV2EkNQVDfXpy bAhhW3BcEkIsJxR7 Qx1QCG4DYzJ9aWFK Ul0KdgMGbQNKfBpM alN8U3ZYYytlM3Bw LCYfGhEXCH12NThS XAgGJk8XCUgCHzoh XR1KAjQzHQU9QD4v IAYrMRZMWh1Xaxll eRskUEJdPQQXPRVX EExWYmdYPEIcSn1q ZQAA X-Authentic-SMTP: 61633235383639.1019:706 X-AuthFastPath: 0 (Was 255) X-AuthSMTP-Origin: 58.7.191.252/2525 X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201211/121 X-Sequence-Number: 40366 On 11/23/2012 07:32 PM, Subhasis Bhattacharya wrote: > Hi All, > > Recently a postgres database embedded within our product faced a > series of hiccups at a customer site, as follows: 8.3? An old 8.3 at that? Do you have any upgrade plans? I'm pretty sure I remember seeing this discussed a long time ago, but it hasn't come up recently. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services