[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] Performance autovaccum
From:       Rick Otten <rotten () manta ! com>
Date:       2013-07-10 13:12:16
Message-ID: 7A1B720615F7D9458BE37FA699EF0794154D5E7A () cmhvm033 ! ecnext03 ! local
[Download RAW message or body]

SW4gb3VyIHVzZSBjYXNlLCB0aGUgZGVmYXVsdCBhdXRvdmFjdXVtIHNldHRp
bmdzIGRpZCBub3Qgd29yaywgSSBndWVzcyB3ZSBhcmUgaW4gdGhlIDUlIGdy
b3VwIG9mIHVzZXJzLiAgVGhlIGRlZmF1bHQgc2V0dGluZ3Mgd2VyZSB0b28g
YWdncmVzc2l2ZSB3aGVuIGl0IHJhbiBhZ2FpbnN0IHNvbWUgb2Ygb3VyIGxh
cmdlciB0YWJsZXMgKGV4YW1wbGU6ICAxMDBNIHJvd3MgYnkgMjUwIGNvbHVt
bnMpIGluIG91ciBmcm9udCBlbmQgT0xUUCBkYXRhYmFzZSBjYXVzaW5nIHNl
dmVyZSBwZXJmb3JtYW5jZSBkZWdyYWRhdGlvbi4gICBXZSBoYWQgdG8gdGhy
b3R0bGUgaXQgYmFjayAoYW5kIGhhdmVuJ3QgaGFkIHByb2JsZW1zIHNpbmNl
KS4NCg0KWW91IHNob3VsZCBkZWZpbml0ZWx5IHJ1biBhdXRvdmFjdXVtLiAg
SWYgeW91IGFyZSBvbmx5IGFibGUgdG8gZXhwZXJpbWVudCB3aXRoIGl0IGlu
IHByb2R1Y3Rpb24sIEkgcmVjb21tZW5kIHRha2luZyBpdCBzbG93IGF0IGZp
cnN0LCBhbmQgZ3JhZHVhbGx5IG1ha2luZyBpdCBtb3JlIGFnZ3Jlc3NpdmUg
YWZ0ZXIgeW91IGhhdmUgYSBnb29kIGhhbmRsZSBvbiB0aGUgaW1wYWN0IChh
bmQgb2JzZXJ2ZSBpdCBydW5uaW5nIG9uIHRoZSBsYXJnZXIgY3JpdGljYWwg
dGFibGVzIGluIHlvdXIgZGF0YSBpbnZlbnRvcnkgd2l0aG91dCBpbXBhY3Qp
LiAgWW91IGNhbiBzdGFydCB3aXRoIHRoZSBkZWZhdWx0cywgdGhleSBhcmVu
J3QgdG9vIGJhZC4gIEluIG91ciBjYXNlIC0gYSBiYWNrZW5kIGZvciBhIGhp
Z2ggcGVyZm9ybWFuY2UsIGhpZ2hseSBhdmFpbGFibGUgd2Vic2l0ZSB3aXRo
IGEgc2V0IG9mIHdlYnNlcnZlcnMgdGhhdCBhcmUgdmVyeSBzZW5zaXRpdmUg
dG8gZXZlbiBzbGlnaHQgcXVlcnkgdGltZSBjaGFuZ2VzLCB0aGUgZGVmYXVs
dCBzZXR0aW5ncyBzaW1wbHkgY29uc3VtZWQgdG9vIG11Y2ggb3ZlcmhlYWQu
ICBJIHRoaW5rIGluIHRoZSBlbmQgYWxsIHdlIGhhZCB0byBjaGFuZ2Ugd2Fz
IHRoZSBhdXRvdmFjdXVtX3ZhY3V1bV9jb3N0X2RlbGF5IHRvIG1ha2UgZW5v
dWdoIGRpZmZlcmVuY2UgdG8ga2VlcCBvdXIgc2l0ZSB1cCBhbmQgcnVubmlu
Zy4gIFlvdSBzaG91bGQgcmV2aWV3IHRoZSB0dW5pbmcgb3B0aW9ucyB0aG91
Z2guDQoNClRoZSBwcm9ibGVtIGlzIGlmIHlvdSBraWxsIHRoZSBhdXRvdmFj
dXVtIHByb2Nlc3MgYmVjYXVzZSB5b3Ugc3VzcGVjdCBpdCBpcyBjYXVzaW5n
IGlzc3VlcyBkdXJpbmcgYSBjcmlzaXMsIHRoZSBhdXRvdmFjdXVtZXIgd2ls
bCBqdXN0IHN0YXJ0IGl0IGJhY2sgdXAgYWdhaW4gYSBmZXcgbWludXRlcyBs
YXRlci4gIElmIHlvdSBkaXNhYmxlIGl0IHBlcm1hbmVudGx5IHlvdXIgcXVl
cnkgcGVyZm9ybWFuY2Ugd2lsbCBsaWtlbHkgc2xvd2x5IGRlZ3JhZGUuICBZ
b3UgbmVlZCB0byBmaW5kIHNvbWV3aGVyZSBpbiBiZXR3ZWVuLg0KDQpPaCAt
IG9uZSBsYXN0IG5vdGU6ICBJZiB5b3UgaGF2ZSBhIHBhcnRpdGlvbmVkIHRh
YmxlIChwYXJ0aXRpb25lZCBieSBkYXRlKSwgYXV0b3ZhY3V1bSB3aWxsIG5v
dCBydW4gYWdhaW5zdCB0aGUgb2xkZXIgcGFydGl0aW9ucyAoYmVjYXVzZSB0
aGV5IGFyZSBubyBsb25nZXIgY2hhbmdpbmcpLiAgSWYgeW91J3ZlIGhhZCBh
dXRvdmFjdXVtIG9mZiBmb3IgYSB3aGlsZSwgeW91IG1heSBuZWVkIHRvIGdv
IGJhY2sgYW5kIG1hbnVhbGx5IHZhY3V1bSBhbmFseXplIHRoZSBvbGRlciBw
YXJ0aXRpb25zIHRvIGNsZWFuIHRoZW0gdXAgYWZ0ZXIgeW91IGdldCBhdXRv
dmFjdXVtIHJ1bm5pbmcuICAoZGl0dG8gZm9yIG90aGVyIG9sZCB0YWJsZXMg
dGhhdCBhcmUgbm8gbG9uZ2VyIGNoYW5naW5nKQ0KDQoNCi0tLS0tT3JpZ2lu
YWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBwZ3NxbC1wZXJmb3JtYW5jZS1vd25l
ckBwb3N0Z3Jlc3FsLm9yZyBbbWFpbHRvOnBnc3FsLXBlcmZvcm1hbmNlLW93
bmVyQHBvc3RncmVzcWwub3JnXSBPbiBCZWhhbGYgT2YgSm9zaHVhIEQuIERy
YWtlDQpTZW50OiBUdWVzZGF5LCBKdWx5IDA5LCAyMDEzIDg6NDIgUE0NClRv
OiBKb3NoIEJlcmt1cw0KQ2M6IHBnc3FsLXBlcmZvcm1hbmNlQHBvc3RncmVz
cWwub3JnDQpTdWJqZWN0OiBSZTogW1BFUkZPUk1dIFBlcmZvcm1hbmNlIGF1
dG92YWNjdW0NCg0KDQpPbiAwNy8wOS8yMDEzIDAzOjE0IFBNLCBKb3NoIEJl
cmt1cyB3cm90ZToNCj4NCj4gT24gMDcvMDgvMjAxMyAwOToxNCBBTSwgSmVp
c29uIEJlZG95YSB3cm90ZToNCj4+IEhpLCBpIGhhdmUgYSBwb3N0Z3Jlc3Fs
IDkuMi4yLCBidXQgaSBkb27CtHQgdXNlIGF1dG92YWNjdW0gYnV0IGkgd2Fu
dCANCj4+IHRvIGJlZ2luIHRvIHVzZSBpdC4gIHNvbWUgcmVjb21tZW5kYXRp
b24gYWJvdXQgdGhlIG9wdGltYWwgY29uZmlndXJhdGlvbj8NCj4+IG9yIHNv
bWUgbGluayB0byBleHBsYWluIGl0Lg0KPg0KPiBJbml0aWFsIGNvbmZpZ3Vy
YXRpb246DQo+DQo+IGF1dG92YWN1dW0gPSBvbg0KPg0KPiBUaGVyZSwgeW91
J3JlIGRvbmUuICBZb3Ugb25seSBkbyBzb21ldGhpbmcgZWxzZSBpZiB0aGUg
ZGVmYXVsdCANCj4gY29uZmlndXJhaXRvbiBpcyBwcm92ZW4gbm90IHRvIHdv
cmsgZm9yIHlvdS4NCj4NCg0KV2VsbCwgYW5kIGEgcmVzdGFydCBvZiBQb3N0
Z3JlU1FMLiBJdCBzaG91bGQgYWxzbyBiZSBub3RlZCB0aGF0IGF1dG92YWN1
dW0gYnkgZGVmYXVsdCBpcyBvbi4gWW91IGNhbiBjaGVjayB0byBzZWUgaWYg
aXQgaXMgY3VycmVudGx5IHJ1bm5pbmcgZm9yIHlvdSBieSBpc3N1aW5nIHRo
ZSBmb2xsb3dpbmcgY29tbWFuZCBmcm9tIHBzcWw6DQoNCnNob3cgYXV0b3Zh
Y3V1bTsNCg0KT3RoZXIgdGhhbiB0aGF0IEpvc2hCIGlzIGNvcnJlY3QuIFRo
ZSBkZWZhdWx0IHNldHRpbmdzIGZvciBhdXRvdmFjdXVtIHdvcmsgZm9yIHRo
ZSA5NSUgb2YgdXNlcnMgb3V0IHRoZXJlLg0KDQpKRA0KDQoNCg0KLS0NCkNv
bW1hbmQgUHJvbXB0LCBJbmMuIC0gaHR0cDovL3d3dy5jb21tYW5kcHJvbXB0
LmNvbS8gIDUwOS00MTYtNjU3OSBQb3N0Z3JlU1FMIFN1cHBvcnQsIFRyYWlu
aW5nLCBQcm9mZXNzaW9uYWwgU2VydmljZXMgYW5kIERldmVsb3BtZW50IEhp
Z2ggQXZhaWxhYmlsaXR5LCBPcmFjbGUgQ29udmVyc2lvbiwgUG9zdGdyZXMt
WEMsIEBjbWRwcm9tcHRpbmMgRm9yIG15IGRyZWFtcyBvZiB5b3VyIGltYWdl
IHRoYXQgYmxvc3NvbXMNCiAgICBhIHJvc2UgaW4gdGhlIGRlZXBzIG9mIG15
IGhlYXJ0LiAtIFcuQi4gWWVhdHMNCg0KDQotLSANClNlbnQgdmlhIHBnc3Fs
LXBlcmZvcm1hbmNlIG1haWxpbmcgbGlzdCAocGdzcWwtcGVyZm9ybWFuY2VA
cG9zdGdyZXNxbC5vcmcpDQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJz
Y3JpcHRpb246DQpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVm
L3Bnc3FsLXBlcmZvcm1hbmNlDQoKLS0gClNlbnQgdmlhIHBnc3FsLXBlcmZv
cm1hbmNlIG1haWxpbmcgbGlzdCAocGdzcWwtcGVyZm9ybWFuY2VAcG9zdGdy
ZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlv
bjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1w
ZXJmb3JtYW5jZQo=
[prev in list] [next in list] [prev in thread] [next in thread]