Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ULFkV-0003Zp-8w for pgsql-admin@arkaria.postgresql.org; Thu, 28 Mar 2013 16:32:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1ULFkU-0006fR-KI for pgsql-admin@arkaria.postgresql.org; Thu, 28 Mar 2013 16:32:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ULFkT-0006fL-Bw for pgsql-admin@postgresql.org; Thu, 28 Mar 2013 16:32:21 +0000 Received: from nm30-vm0.bullet.mail.bf1.yahoo.com ([98.139.213.126]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ULFkK-0001mj-0D for pgsql-admin@postgresql.org; Thu, 28 Mar 2013 16:32:20 +0000 Received: from [98.139.212.144] by nm30.bullet.mail.bf1.yahoo.com with NNFMP; 28 Mar 2013 16:32:09 -0000 Received: from [98.139.212.241] by tm1.bullet.mail.bf1.yahoo.com with NNFMP; 28 Mar 2013 16:32:09 -0000 Received: from [127.0.0.1] by omp1050.mail.bf1.yahoo.com with NNFMP; 28 Mar 2013 16:32:09 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 917853.6589.bm@omp1050.mail.bf1.yahoo.com Received: (qmail 44623 invoked by uid 60001); 28 Mar 2013 16:32:09 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1364488329; bh=o5kskkxpkepCKgNUl8FDZ8P2ozbJTeBAeEkaOLGjoHU=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=fKZWj26S4nvokVOf0DDg3d66pe6dGOnomSl5fvJbLluIcSABZ3v6m4wgxaUf+5TCEwKlmtlxvKOC9wo4dryVJEEJZ73w2Kq+XhVZ9M7503dMkH0HL5DywDvNZego55hx7U13QRLKjS3GIdL+82TgsbXgR//OBusd3Xb86A9s1FM= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=bzkspPsx/K28yWDWEUWk9QGOPCLjRPRmNCG+OwpFSsZfpstlFVgEfhNSA1CIEB25vLlzVUQxPi84oCg7woloVb3lYRK3Q1rppo0fssN8Kcno86MVgwwqoEe54FbsAzxokxQ7QLPx3T1YBS2A9acAhli+Ws4bW+M/YcEiji6C5jk=; X-YMail-OSG: HOme_74VM1nR4vcLygU6A3Vn.cKWXAQAuPINbTL.9ewMkZH tDgyjzSZdOdFAuqVK.EmdmwDDIYPgvhEu1U2o.mqGGBc9hUsIIfW4hwUrsr2 _0E1vSYhRJHbpGU.PIFHV2iJTRhkUM0S3DfxKxw2kFOYxXaUsDewOtK3tCtp nqx.KvECNkBlE803PeI9vDbtDm9UkF1fOLtmkyDqiuvUiZtpKGe4LAt.1KL7 yX7kgyitXhqbSxlPuy5bE2M5QkpVghhWYKQlvIcmvSaw7fuZ2p8y7HiwaQ5L VSuJRfvQgnHjZtsLmk8b2hfwVsMjceeelzI.etbT0n7xEgWxucpxfZ7zbKnX S8QBgQ28ASsLYVi19pNmUPi0HI2yGEy9IgylRHu.fbPigBaQeg.Dp2JxUXn9 v0tg52KT79izUfWv1bI2PBmmmwW._tGonzPUnawjIh_vB7xqybqX9xuAvCAl d2ksoR80o6enACEHsaUWACbyWkgwzoiDU4qVKXz1AXCKwgzj4ywy5yVbBwsa Tzs77QeLeDAYqYQ37W8kzDSwebzlIH3h0Bj6lhxBUm1LMnu03lkecWfdkLIQ tP2OpE8f74Y4JpmpNe.CzNcniFCflTjySSqKz4siq6ukh1oFw0h8RU8vSzFA 5A6_CBrw- Received: from [76.255.18.237] by web162906.mail.bf1.yahoo.com via HTTP; Thu, 28 Mar 2013 09:32:09 PDT X-Rocket-MIMEInfo: 002.001, c3VoYXMuYmFzYXZhcmFqMTIgPHN1aGFzLmJAdmVyc2UuaW4.IHdyb3RlOgoKPiBUaGlzIHdhcyBvYnNlcnZlZCBpbiBwb3N0Z3JlcyA5LjAuMS4KCllvdSBtaWdodCB3YW50IHRvIHJldmlldyB0aGUgYnVnIGZpeGVzIGluIDkuMCBtYWludGVuYW5jZSByZWxlYXNlcwphbmQgc2VlIGlmIGFueSBvZiB0aGVtIGNvdWxkIGJlIHJlc3BvbnNpYmxlIGZvciB3aGF0IHlvdSBzYXc6CgpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvOS4wL3N0YXRpYy9yZWxlYXNlLTktMC0yLmh0bWwKaHR0cDovL3d3dy5wb3MBMAEBAQE- X-Mailer: YahooMailWebService/0.8.139.530 References: <1364472421615-5749963.post@n5.nabble.com> Message-ID: <1364488329.29392.YahooMailNeo@web162906.mail.bf1.yahoo.com> Date: Thu, 28 Mar 2013 09:32:09 -0700 (PDT) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: VACUUM ANALYZE AND ANALYZE ISSUE To: "suhas.basavaraj12" , "pgsql-admin@postgresql.org" In-Reply-To: <1364472421615-5749963.post@n5.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org suhas.basavaraj12 wrote: > This was observed in postgres 9.0.1. You might want to review the bug fixes in 9.0 maintenance releases and see if any of them could be responsible for what you saw: http://www.postgresql.org/docs/9.0/static/release-9-0-2.html http://www.postgresql.org/docs/9.0/static/release-9-0-3.html http://www.postgresql.org/docs/9.0/static/release-9-0-4.html http://www.postgresql.org/docs/9.0/static/release-9-0-5.html http://www.postgresql.org/docs/9.0/static/release-9-0-6.html http://www.postgresql.org/docs/9.0/static/release-9-0-7.html http://www.postgresql.org/docs/9.0/static/release-9-0-8.html http://www.postgresql.org/docs/9.0/static/release-9-0-9.html http://www.postgresql.org/docs/9.0/static/release-9-0-10.html http://www.postgresql.org/docs/9.0/static/release-9-0-11.html http://www.postgresql.org/docs/9.0/static/release-9-0-12.html ... or just apply all of those bug fixes and see if you can make it happen again. In general, it pays to apply fixes as they become available. http://www.postgresql.org/support/versioning/ -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin