Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X4G6w-0000BE-KI for pgsql-general@arkaria.postgresql.org; Mon, 07 Jul 2014 21:06:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1X4G6v-0005ji-Mf for pgsql-general@arkaria.postgresql.org; Mon, 07 Jul 2014 21:06:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1X4G6u-0005jS-J4; Mon, 07 Jul 2014 21:06:04 +0000 Received: from mail.journyx.com ([209.163.206.41] helo=mail.int.journyx.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X4G6m-0003No-09; Mon, 07 Jul 2014 21:06:01 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.int.journyx.com (Postfix) with ESMTP id 7B51D30029A; Mon, 7 Jul 2014 16:05:51 -0500 (CDT) Received: from mail.int.journyx.com ([127.0.0.1]) by localhost (mail.int.journyx.com [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id GJgDGrXM58uI; Mon, 7 Jul 2014 16:05:47 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by mail.int.journyx.com (Postfix) with ESMTP id A8A563002A0; Mon, 7 Jul 2014 16:05:47 -0500 (CDT) X-Virus-Scanned: amavisd-new at mail.int.journyx.com Received: from mail.int.journyx.com ([127.0.0.1]) by localhost (mail.int.journyx.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id FXENVmHNeF6x; Mon, 7 Jul 2014 16:05:47 -0500 (CDT) Received: from mail.int.journyx.com (zimbra.int.journyx.com [192.168.100.5]) by mail.int.journyx.com (Postfix) with ESMTP id 7A65830029A; Mon, 7 Jul 2014 16:05:47 -0500 (CDT) Date: Mon, 7 Jul 2014 16:05:47 -0500 (CDT) Subject: Re: [ADMIN] WARNING: database must be vacuumed within 8439472 transactions Message-ID: Importance: normal From: Scott Whitney To: Prabhjot Sheena , Alvaro Herrera Cc: "pgsql-admin@postgresql.org" , Forums postgresql MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="--_com.android.email_483520579244570" X-Mailer: Zimbra 8.0.7_GA_6021 (MobileSync - SAMSUNG-SGH-I337/101.40402) Thread-Topic: WARNING: database must be vacuumed within 8439472 transactions Thread-Index: FhUVDHzScH1Y5yqyWiRQ5zawJsCNYw== X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org ----_com.android.email_483520579244570 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 WWVzLiBUaGF0J3Mgd2hhdCBJIHdhcyByZWZlcnJpbmcgdG8uIEJhY2sgaW4gbXkgOC4zIGRheXMs IEkgd2FzIHJlcXVpcmVkIHRvIGRvIGEgRlVMTCB2YWN1dW0gZXZlcnkgd2Vlay4gSSBkaXNjdXNz ZWQgaXQgcXVpdGUgYSBiaXQgb24gdGhpcyBsaXN0LCBhbmQgdGhlcmUgd2VyZSBtYW55IHBlb3Bs ZSB3aG8gc2FpZCBpdCBzaG91bGQgbm90IGhhdmUgYmVlbiByZXF1aXJlZCwgYnV0IGl0IHdhcywg YW5kIGl0IHJlc29sdmVkIG15IHBhcnRpY3VsYXIgaXNzdWVzIChjbG9ncyBub3QgZ2V0dGluZyBy ZW1vdmVkIHVudGlsIGZ1bGwgdmFjKS4gSSB3b3VsZCByZWNvbW1lbmQgaXQuCgo8ZGl2Pi0tLS0t LS0tIE9yaWdpbmFsIG1lc3NhZ2UgLS0tLS0tLS08L2Rpdj48ZGl2PkZyb206IFByYWJoam90IFNo ZWVuYSA8cHJhYmhqb3Quc2hlZW5hQHJpdmFsd2F0Y2guY29tPiA8L2Rpdj48ZGl2PkRhdGU6MDcv MDcvMjAxNCAgMzo0NiBQTSAgKEdNVC0wNjowMCkgPC9kaXY+PGRpdj5UbzogQWx2YXJvIEhlcnJl cmEgPGFsdmhlcnJlQDJuZHF1YWRyYW50LmNvbT4gPC9kaXY+PGRpdj5DYzogcGdzcWwtYWRtaW5A cG9zdGdyZXNxbC5vcmcsRm9ydW1zIHBvc3RncmVzcWwgPHBnc3FsLWdlbmVyYWxAcG9zdGdyZXNx bC5vcmc+IDwvZGl2PjxkaXY+U3ViamVjdDogUmU6IFtBRE1JTl0gW0dFTkVSQUxdIFdBUk5JTkc6 IGRhdGFiYXNlIG11c3QgYmUgdmFjdXVtZWQgd2l0aGluIDg0Mzk0NzIgdHJhbnNhY3Rpb25zIDwv ZGl2PjxkaXY+CjwvZGl2PldoaWxlIHRoZSB2YWN1dW1kYiAtLWFuYWx5emUgY29tbWFuZCBpcyBy dW5uaW5nIGkgbSBnZXR0aW5nIHRoZXNlIG1lc3NhZ2VzIGZvciB0aGVzZSB0YWJsZXMgd2hpY2gg bWlnaHQgcmVxdWlyZSBmdWxsIHZhY3V1bS4gCgpXQVJOSU5HOiAgcmVsYXRpb24gInB1YmxpYy5y ZXN1bHQiIGNvbnRhaW5zIG1vcmUgdGhhbiAibWF4X2ZzbV9wYWdlcyIgcGFnZXMgd2l0aCB1c2Vm dWwgZnJlZSBzcGFjZQpISU5UOiAgQ29uc2lkZXIgdXNpbmcgVkFDVVVNIEZVTEwgb24gdGhpcyBy ZWxhdGlvbiBvciBpbmNyZWFzaW5nIHRoZSBjb25maWd1cmF0aW9uIHBhcmFtZXRlciAibWF4X2Zz bV9wYWdlcyIuCgpXQVJOSU5HOiAgcmVsYXRpb24gInB1YmxpYy5ydW4iIGNvbnRhaW5zIG1vcmUg dGhhbiAibWF4X2ZzbV9wYWdlcyIgcGFnZXMgd2l0aCB1c2VmdWwgZnJlZSBzcGFjZQpISU5UOiAg Q29uc2lkZXIgdXNpbmcgVkFDVVVNIEZVTEwgb24gdGhpcyByZWxhdGlvbiBvciBpbmNyZWFzaW5n IHRoZSBjb25maWd1cmF0aW9uIHBhcmFtZXRlciAibWF4X2ZzbV9wYWdlcyIuCgoKCgoKT24gTW9u LCBKdWwgNywgMjAxNCBhdCAxOjMxIFBNLCBBbHZhcm8gSGVycmVyYSA8YWx2aGVycmVAMm5kcXVh ZHJhbnQuY29tPiB3cm90ZToKUHJhYmhqb3QgU2hlZW5hIHdyb3RlOgo+IEhlbGxvCj4gICAgICAg IFdlIGFyZSB1c2luZyBwb3N0Z3Jlc3FsIDguMyBkYXRhYmFzZSBmb3IgbGFzdCA1IHlycyBmb3Ig dGhpcwo+IHByb2R1Y3Rpb24gZGF0YWJhc2UgYW5kIGl0cyBydW5uaW5nIGZpbmUuIFRoaXMgaXMg b3VyIGNyaXRpY2FsIGRhdGFiYXNlCj4gd2hpY2ggcnVucyAyNCo3LiBUaGlzIHdlZWtlbmQgd2Ug c3RhcnRlZCBnZXR0aW5nIHRoZXNlIG1lc3NhZ2VzCj4KPiBISU5UOiAgVG8gYXZvaWQgYSBkYXRh YmFzZSBzaHV0ZG93biwgZXhlY3V0ZSBhIGZ1bGwtZGF0YWJhc2UgVkFDVVVNLgo+IFdBUk5JTkc6 ICBkYXRhYmFzZSAgbXVzdCBiZSB2YWN1dW1lZCB3aXRoaW4gODQzOTQ3MiB0cmFuc2FjdGlvbnMK CkRpZCB5b3Ugb21pdCB0aGUgZGF0YWJhc2UgbmFtZSBoZXJlLCBvciBpcyBpdCByZWFsbHkgYW4g ZW1wdHkgc3RyaW5nPwpNYWtlIHN1cmUgeW91IHZhY3V1bSBleGFjdGx5IHRoZSBkYXRhYmFzZSBt ZW50aW9uZWQgdGhlcmUuICBBdXRvdmFjdXVtCnNob3VsZCBiZSBkb2luZyBpdCwgdGhvdWdoLCBi dXQgcGVyaGFwcyBpdCdzIGR5aW5nIGZvciBzb21lIHJlYXNvbiBhbmQKaXQgY2FuJ3QgdmFjdXVt IG9uZSB0YWJsZSBpbiBwYXJ0aWN1bGFyLiAgWW91IHNob3VsZCBjaGVjayB5b3VyIGxvZyBmb3IK ZXJyb3JzLgoKLS0Kw4FsdmFybyBIZXJyZXJhICAgICAgICAgICAgICAgIGh0dHA6Ly93d3cuMm5k UXVhZHJhbnQuY29tLwpQb3N0Z3JlU1FMIERldmVsb3BtZW50LCAyNHg3IFN1cHBvcnQsIFRyYWlu aW5nICYgU2VydmljZXMKCg== ----_com.android.email_483520579244570 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 PGh0bWw+PGhlYWQ+PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0 L2h0bWw7IGNoYXJzZXQ9VVRGLTgiPjwvaGVhZD48Ym9keSA+WWVzLiBUaGF0J3Mgd2hhdCBJIHdh cyByZWZlcnJpbmcgdG8uIEJhY2sgaW4gbXkgOC4zIGRheXMsIEkgd2FzIHJlcXVpcmVkIHRvIGRv IGEgRlVMTCB2YWN1dW0gZXZlcnkgd2Vlay4gSSBkaXNjdXNzZWQgaXQgcXVpdGUgYSBiaXQgb24g dGhpcyBsaXN0LCBhbmQgdGhlcmUgd2VyZSBtYW55IHBlb3BsZSB3aG8gc2FpZCBpdCBzaG91bGQg bm90IGhhdmUgYmVlbiByZXF1aXJlZCwgYnV0IGl0IHdhcywgYW5kIGl0IHJlc29sdmVkIG15IHBh cnRpY3VsYXIgaXNzdWVzIChjbG9ncyBub3QgZ2V0dGluZyByZW1vdmVkIHVudGlsIGZ1bGwgdmFj KS4gSSB3b3VsZCByZWNvbW1lbmQgaXQuPGJyPjxicj48ZGl2Pi0tLS0tLS0tIE9yaWdpbmFsIG1l c3NhZ2UgLS0tLS0tLS08L2Rpdj48ZGl2PkZyb206IFByYWJoam90IFNoZWVuYSA8cHJhYmhqb3Qu c2hlZW5hQHJpdmFsd2F0Y2guY29tPiA8L2Rpdj48ZGl2PkRhdGU6MDcvMDcvMjAxNCAgMzo0NiBQ TSAgKEdNVC0wNjowMCkgPC9kaXY+PGRpdj5UbzogQWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQDJu ZHF1YWRyYW50LmNvbT4gPC9kaXY+PGRpdj5DYzogcGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcs Rm9ydW1zIHBvc3RncmVzcWwgPHBnc3FsLWdlbmVyYWxAcG9zdGdyZXNxbC5vcmc+IDwvZGl2Pjxk aXY+U3ViamVjdDogUmU6IFtBRE1JTl0gW0dFTkVSQUxdIFdBUk5JTkc6IGRhdGFiYXNlIG11c3Qg YmUgdmFjdXVtZWQgd2l0aGluIDg0Mzk0NzIgdHJhbnNhY3Rpb25zIDwvZGl2PjxkaXY+PGJyPjwv ZGl2PjxkaXYgZGlyPSJsdHIiPldoaWxlIHRoZSB2YWN1dW1kYiAtLWFuYWx5emUgY29tbWFuZCBp cyBydW5uaW5nIGkgbSBnZXR0aW5nIHRoZXNlIG1lc3NhZ2VzIGZvciB0aGVzZSB0YWJsZXMgd2hp Y2ggbWlnaHQgcmVxdWlyZSBmdWxsIHZhY3V1bS4gPGJyPjxicj5XQVJOSU5HOiZuYnNwOyByZWxh dGlvbiAicHVibGljLnJlc3VsdCIgY29udGFpbnMgbW9yZSB0aGFuICJtYXhfZnNtX3BhZ2VzIiBw YWdlcyB3aXRoIHVzZWZ1bCBmcmVlIHNwYWNlPGJyPgpISU5UOiZuYnNwOyBDb25zaWRlciB1c2lu ZyBWQUNVVU0gRlVMTCBvbiB0aGlzIHJlbGF0aW9uIG9yIGluY3JlYXNpbmcgdGhlIGNvbmZpZ3Vy YXRpb24gcGFyYW1ldGVyICJtYXhfZnNtX3BhZ2VzIi48YnI+PGJyPldBUk5JTkc6Jm5ic3A7IHJl bGF0aW9uICJwdWJsaWMucnVuIiBjb250YWlucyBtb3JlIHRoYW4gIm1heF9mc21fcGFnZXMiIHBh Z2VzIHdpdGggdXNlZnVsIGZyZWUgc3BhY2U8YnI+CkhJTlQ6Jm5ic3A7IENvbnNpZGVyIHVzaW5n IFZBQ1VVTSBGVUxMIG9uIHRoaXMgcmVsYXRpb24gb3IgaW5jcmVhc2luZyB0aGUgY29uZmlndXJh dGlvbiBwYXJhbWV0ZXIgIm1heF9mc21fcGFnZXMiLjxicj48YnI+PGJyPjxicj48L2Rpdj48ZGl2 IGNsYXNzPSJnbWFpbF9leHRyYSI+PGJyPjxicj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+T24g TW9uLCBKdWwgNywgMjAxNCBhdCAxOjMxIFBNLCBBbHZhcm8gSGVycmVyYSA8c3BhbiBkaXI9Imx0 ciI+Jmx0OzxhIGhyZWY9Im1haWx0bzphbHZoZXJyZUAybmRxdWFkcmFudC5jb20iIHRhcmdldD0i X2JsYW5rIj5hbHZoZXJyZUAybmRxdWFkcmFudC5jb208L2E+Jmd0Ozwvc3Bhbj4gd3JvdGU6PGJy Pgo8YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJnaW46MCAwIDAgLjhl eDtib3JkZXItbGVmdDoxcHggI2NjYyBzb2xpZDtwYWRkaW5nLWxlZnQ6MWV4Ij48ZGl2IGNsYXNz PSIiPlByYWJoam90IFNoZWVuYSB3cm90ZTo8YnI+CiZndDsgSGVsbG88YnI+CiZndDsgJm5ic3A7 ICZuYnNwOyAmbmJzcDsgJm5ic3A7V2UgYXJlIHVzaW5nIHBvc3RncmVzcWwgOC4zIGRhdGFiYXNl IGZvciBsYXN0IDUgeXJzIGZvciB0aGlzPGJyPgomZ3Q7IHByb2R1Y3Rpb24gZGF0YWJhc2UgYW5k IGl0cyBydW5uaW5nIGZpbmUuIFRoaXMgaXMgb3VyIGNyaXRpY2FsIGRhdGFiYXNlPGJyPgomZ3Q7 IHdoaWNoIHJ1bnMgMjQqNy4gVGhpcyB3ZWVrZW5kIHdlIHN0YXJ0ZWQgZ2V0dGluZyB0aGVzZSBt ZXNzYWdlczxicj4KJmd0Ozxicj4KJmd0OyBISU5UOiAmbmJzcDtUbyBhdm9pZCBhIGRhdGFiYXNl IHNodXRkb3duLCBleGVjdXRlIGEgZnVsbC1kYXRhYmFzZSBWQUNVVU0uPGJyPgomZ3Q7IFdBUk5J Tkc6ICZuYnNwO2RhdGFiYXNlICZuYnNwO211c3QgYmUgdmFjdXVtZWQgd2l0aGluIDg0Mzk0NzIg dHJhbnNhY3Rpb25zPGJyPgo8YnI+CjwvZGl2PkRpZCB5b3Ugb21pdCB0aGUgZGF0YWJhc2UgbmFt ZSBoZXJlLCBvciBpcyBpdCByZWFsbHkgYW4gZW1wdHkgc3RyaW5nPzxicj4KTWFrZSBzdXJlIHlv dSB2YWN1dW0gZXhhY3RseSB0aGUgZGF0YWJhc2UgbWVudGlvbmVkIHRoZXJlLiAmbmJzcDtBdXRv dmFjdXVtPGJyPgpzaG91bGQgYmUgZG9pbmcgaXQsIHRob3VnaCwgYnV0IHBlcmhhcHMgaXQncyBk eWluZyBmb3Igc29tZSByZWFzb24gYW5kPGJyPgppdCBjYW4ndCB2YWN1dW0gb25lIHRhYmxlIGlu IHBhcnRpY3VsYXIuICZuYnNwO1lvdSBzaG91bGQgY2hlY2sgeW91ciBsb2cgZm9yPGJyPgplcnJv cnMuPGJyPgo8c3BhbiBjbGFzcz0iSE9FblpiIj48Zm9udCBjb2xvcj0iIzg4ODg4OCI+PGJyPgot LTxicj4Kw4FsdmFybyBIZXJyZXJhICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsg Jm5ic3A7ICZuYnNwOyAmbmJzcDs8YSBocmVmPSJodHRwOi8vd3d3LjJuZFF1YWRyYW50LmNvbS8i IHRhcmdldD0iX2JsYW5rIj5odHRwOi8vd3d3LjJuZFF1YWRyYW50LmNvbS88L2E+PGJyPgpQb3N0 Z3JlU1FMIERldmVsb3BtZW50LCAyNHg3IFN1cHBvcnQsIFRyYWluaW5nICZhbXA7IFNlcnZpY2Vz PGJyPgo8L2ZvbnQ+PC9zcGFuPjwvYmxvY2txdW90ZT48L2Rpdj48YnI+PC9kaXY+CjwvYm9keT4= ----_com.android.email_483520579244570--