Re: BUG #9635: Wal sender process is using 100% CPU - Mailing list pgsql-bugs
From | Jamie Koceniak |
---|---|
Subject | Re: BUG #9635: Wal sender process is using 100% CPU |
Date | |
Msg-id | 84CE67AB46ACDA41B18094177DD0853D212DA8@ORD2MBX04C.mex05.mlsrvr.com Whole thread Raw |
In response to | Re: BUG #9635: Wal sender process is using 100% CPU (Heikki Linnakangas <hlinnakangas@vmware.com>) |
List | pgsql-bugs |
SSB3YXMgYWJsZSB0byByZWNyZWF0ZSB0aGUgaXNzdWUuDQpCYXNpY2FsbHksIHdlIGhhdmUgYSBq b2IgdGhhdCBpbnNlcnRzIDMwKyBtaWxsaW9uIHJlY29yZHMgaW50byBhIHRhYmxlLg0KRHVyaW5n IHRoZSBsb2FkaW5nIG9mIHRoaXMgdGFibGUsIHRoZSB3YWxfc2VuZGVyIGNwdSBzcGlrZXMgdG8g MTAwJSBhbmQgYXBwZWFycyB0byBzdGF5IGF0IDEwMCUgdW50aWwgdGhlIHJlcGxpY2F0aW9uIGlz IGNvbXBsZXRlZCBvbiB0aGUgc2xhdmUuDQpJIHdhcyBhYmxlIHRvIHRlc3QgaW5zZXJ0aW5nIHRo aXMgbXVjaCBkYXRhIG9uIGFub3RoZXIgbWFzdGVyL3NsYXZlIGNvbmZpZ3VyYXRpb24gd2l0aCBz dHJlYW1pbmcgcmVwbGljYXRpb24gYW5kIHNhdyB0aGUgc2FtZSByZXN1bHRzLg0KDQpPdGhlciB0 aGFuIG9mZmxvYWRpbmcgdGhpcyBqb2IsIGlzIHRoZXJlIGFueXRoaW5nIHdlIGNhbiBkbyB0byBk ZWNyZWFzZSB0aGUgcmVwbGljYXRpb24gbGFnPw0KQWxzbywgaXMgdGhpcyBleHBlY3RlZCBiZWhh dmlvciBkdWUgdG8gdGhlIHZvbHVtZSBvZiBkYXRhIHRoYXQgZ290IGluc2VydGVkIGFuZCBuZWVk cyB0byBnZXQgcmVwbGljYXRlZD8NCg0KVGhhbmtzIQ0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2Ut LS0tLQ0KRnJvbTogSGVpa2tpIExpbm5ha2FuZ2FzIFttYWlsdG86aGxpbm5ha2FuZ2FzQHZtd2Fy ZS5jb21dIA0KU2VudDogVHVlc2RheSwgTWF5IDA2LCAyMDE0IDEwOjMzIEFNDQpUbzogSmFtaWUg S29jZW5pYWsNCkNjOiBwZ3NxbC1idWdzQHBvc3RncmVzcWwub3JnDQpTdWJqZWN0OiBSZTogW0JV R1NdIEJVRyAjOTYzNTogV2FsIHNlbmRlciBwcm9jZXNzIGlzIHVzaW5nIDEwMCUgQ1BVDQoNCk9u IDA1LzA2LzIwMTQgMDc6NDQgUE0sIEphbWllIEtvY2VuaWFrIHdyb3RlOg0KPiBIaSBIZWlra2ks DQo+DQo+IEF0dGFjaGVkIGlzIGEgdHJhY2Ugcm91dGUgZm9yIG9uZSBvZiB0aGUgcGlkcyB0aGF0 IHdhcyBydW5uaW5nIGF0IDEwMCUgY3B1Lg0KPiBOb3RlOiB3aGVuIHRoZSB3YWxfc2VuZGVycyBo aXQgMTAwJSBjcHUsIG91ciBzbGF2ZSBzZXJ2ZXJzIHRlbmQgdG8gbGFnIHRoZSBtYXN0ZXIgZm9y IHVwIHRvIGFyb3VuZCAzLTQgbWludXRlcyB1bnRpbCB0aGUgd2FsX3NlbmRlciBjcHUgdXRpbGl6 YXRpb24gZHJvcHMuIFRoaXMgaXMgdmVyeSBwcm9ibGVtYXRpYyBmb3IgdXMgc2luY2Ugd2UgYXJl IHRyeWluZyB0byB1c2UgdGhlIHNsYXZlcyBmb3IgcmVhZHMgaW4gb3VyIGFwcGxpY2F0aW9uLg0K Pg0KPiBIZXJlIGlzIHBlcmYgdG9wIHJlc3VsdHM6DQo+IDM5LjQ5JSAgbGliei5zby4xLjIuNyAg ICAgICAgICAgWy5dIDB4MDAwMDAwMDAwMDAwMzAxZQ0KPiAgIDMyLjk3JSAgcG9zdGdyZXMgICAg ICAgICAgICAgICAgWy5dIDB4MDAwMDAwMDAwMDBjZjE1MA0KPiAgICA2LjUwJSAgcG9zdGdyZXMg ICAgICAgICAgICAgICAgWy5dIG5vY2FjaGVnZXRhdHRyDQo+ICAgIDIuNjMlICBwb3N0Z3JlcyAg ICAgICAgICAgICAgICBbLl0gYnRpbnQ0Y21wDQo+ICAgIDEuNjQlICBwb3N0Z3JlcyAgICAgICAg ICAgICAgICBbLl0gX3N0YXJ0DQo+ICAgIDEuNDAlICBbdW5rbm93bl0gICAgICAgICAgICAgICBb Ll0gMHgwMDAwN2Y5ZGZjYTZhMzRiDQo+ICAgIDEuMDYlICBsaWJjLTIuMTMuc28gICAgICAgICAg ICBbLl0gMHgwMDAwMDAwMDAwMTI5MzRiDQo+ICAgIDAuOTQlICBwb3N0Z3JlcyAgICAgICAgICAg ICAgICBbLl0gc2xvdF9nZXRhdHRyDQo+ICAgIDAuODUlICBsaWJjcnlwdG8uc28uMS4wLjAgICAg ICBbLl0gMHgwMDAwMDAwMDAwMDlmNDhmDQo+ICAgIDAuNjklICBwb3N0Z3JlcyAgICAgICAgICAg ICAgICBbLl0gRXhlY1Byb2plY3QNCj4gICAgMC42NyUgIGxpYnouc28uMS4yLjcgICAgICAgICAg IFsuXSBhZGxlcjMyDQo+ICAgIDAuNjYlICBwb3N0Z3JlcyAgICAgICAgICAgICAgICBbLl0gR2V0 TWVtb3J5Q2h1bmtTcGFjZQ0KPiAgICAwLjU4JSAgW2tlcm5lbF0gICAgICAgICAgICAgICAgW2td IGNvcHlfdXNlcl9nZW5lcmljX3N0cmluZw0KPiAgICAwLjQ1JSAgcG9zdGdyZXMgICAgICAgICAg ICAgICAgWy5dIGhlYXBfZmlsbF90dXBsZQ0KPiAgICAwLjM4JSAgcG9zdGdyZXMgICAgICAgICAg ICAgICAgWy5dIGV4ZWNUdXBsZXNNYXRjaA0KPiAgICAwLjI3JSAgcG9zdGdyZXMgICAgICAgICAg ICAgICAgWy5dIEZ1bmN0aW9uQ2FsbDJDb2xsDQo+ICAgIDAuMjclICBwb3N0Z3JlcyAgICAgICAg ICAgICAgICBbLl0gRXhlY1Byb2NOb2RlDQo+ICAgIDAuMjUlICBwb3N0Z3JlcyAgICAgICAgICAg ICAgICBbLl0gaGVhcF90dXBsZV91bnRvYXN0X2F0dHINCj4gICAgMC4yMiUgIHBvc3RncmVzICAg ICAgICAgICAgICAgIFsuXSBNZW1vcnlDb250ZXh0QWxsb2MNCj4gICAgMC4yMSUgIHBvc3RncmVz ICAgICAgICAgICAgICAgIFsuXSBoZWFwX2Zvcm1fbWluaW1hbF90dXBsZQ0KPiAgICAwLjIxJSAg cG9zdGdyZXMgICAgICAgICAgICAgICAgWy5dIHBmcmVlDQo+ICAgIDAuMTklICBwb3N0Z3JlcyAg ICAgICAgICAgICAgICBbLl0gaGVhcF9jb21wdXRlX2RhdGFfc2l6ZQ0KDQpIbW0sIHRoZXNlIHJl c3VsdHMgc2VlbSB0byBpbmNsdWRlIGFsbCBwcm9jZXNzZXMsIG5vdCBqdXN0IHRoZSBXQUwgc2Vu ZGVyDQoNCj4gICBIZXJlIGlzIHNvbWUgZGF0YSB1c2luZyBwZXJmIHJlY29yZCBhbmQgcGVyZiBy ZXBvcnQ6DQo+DQo+ICsgIDMzLjkzJSAgICAgICAgMTkzMDE5ICAgICAgIHBvc3RncmVzICBwb3N0 Z3JlcyAgICAgICAgICAgICAgICAgIFsuXSAweDAwMDAwMDAwMDAzNjllMjcNCj4gKyAgMzAuMDYl ICAgICAgICAxNzM4MjUgICAgICAgcG9zdGdyZXMgIGxpYnouc28uMS4yLjcgICAgICAgICAgICAg Wy5dIDB4MDAwMDAwMDAwMDAwMzZjMA0KPiArICAxMC4yMSUgICAgICAgICA2MDYxOCAgICAgICBw b3N0Z3JlcyAgW3Vua25vd25dICAgICAgICAgICAgICAgICBbLl0gMHgwMDAwN2Y5ZGZjMmZkNTI5 DQo+ICsgICA0LjgxJSAgICAgICAgIDI3Mjc1ICAgICAgIHBvc3RncmVzICBwb3N0Z3JlcyAgICAg ICAgICAgICAgICAgIFsuXSBub2NhY2hlZ2V0YXR0cg0KPiArICAgMi41NSUgICAgICAgICAxNDQ0 MyAgICAgICBwb3N0Z3JlcyAgcG9zdGdyZXMgICAgICAgICAgICAgICAgICBbLl0gYnRpbnQ0Y21w DQo+ICsgICAxLjIyJSAgICAgICAgICA2OTE2ICAgICAgIHBvc3RncmVzICBwb3N0Z3JlcyAgICAg ICAgICAgICAgICAgIFsuXSBFeGVjUHJvamVjdA0KPiArICAgMS4yMCUgICAgICAgICAgNjgzNyAg ICAgICBwb3N0Z3JlcyAgcG9zdGdyZXMgICAgICAgICAgICAgICAgICBbLl0gX3N0YXJ0DQo+ICsg ICAxLjEwJSAgICAgICAgICA2NDk1ICAgICAgIHBvc3RncmVzICBsaWJjLTIuMTMuc28gICAgICAg ICAgICAgIFsuXSAweDAwMDAwMDAwMDAxMmI4ZTkNCj4gKyAgIDAuODQlICAgICAgICAgIDQ3NjAg ICAgICAgcG9zdGdyZXMgIHBvc3RncmVzICAgICAgICAgICAgICAgICAgWy5dIGhlYXBfZmlsbF90 dXBsZQ0KPiArICAgMC43NCUgICAgICAgICAgNDI2NSAgICAgICBwb3N0Z3JlcyAgW2tlcm5lbC5r YWxsc3ltc10gICAgICAgICBba10gY29weV91c2VyX2dlbmVyaWNfc3RyaW5nDQo+ICsgICAwLjcx JSAgICAgICAgICA0MDAxICAgICAgIHBvc3RncmVzICBwb3N0Z3JlcyAgICAgICAgICAgICAgICAg IFsuXSBHZXRNZW1vcnlDaHVua1NwYWNlDQo+ICsgICAwLjY2JSAgICAgICAgICAzODgxICAgICAg IHBvc3RncmVzICBsaWJjcnlwdG8uc28uMS4wLjAgICAgICAgIFsuXSAweDAwMDAwMDAwMDAwODFl YzcNCj4gKyAgIDAuNjMlICAgICAgICAgIDM2NzMgICAgICAgcG9zdGdyZXMgIGxpYnouc28uMS4y LjcgICAgICAgICAgICAgWy5dIGFkbGVyMzINCj4gKyAgIDAuNDMlICAgICAgICAgIDI0NDggICAg ICAgcG9zdGdyZXMgIHBvc3RncmVzICAgICAgICAgICAgICAgICAgWy5dIHNsb3RfZ2V0YXR0cg0K PiArICAgMC40MCUgICAgICAgICAgMjI3NyAgICAgICBwb3N0Z3JlcyAgcG9zdGdyZXMgICAgICAg ICAgICAgICAgICBbLl0gRXhlY1Byb2NOb2RlDQo+ICsgICAwLjQwJSAgICAgICAgICAyMjUwICAg ICAgIHBvc3RncmVzICBwb3N0Z3JlcyAgICAgICAgICAgICAgICAgIFsuXSBoZWFwX2Zvcm1fbWlu aW1hbF90dXBsZQ0KPiArICAgMC4zNyUgICAgICAgICAgMjA3OCAgICAgICBwb3N0Z3JlcyAgcG9z dGdyZXMgICAgICAgICAgICAgICAgICBbLl0gaGVhcF9jb21wdXRlX2RhdGFfc2l6ZQ0KPiArICAg MC4zMSUgICAgICAgICAgMTczOSAgICAgICBwb3N0Z3JlcyAgcG9zdGdyZXMgICAgICAgICAgICAg ICAgICBbLl0gRXhlY1NjYW4NCj4gKyAgIDAuMjclICAgICAgICAgIDE3NzkgICAgICAgcG9zdGdy ZXMgIFtrZXJuZWwua2FsbHN5bXNdICAgICAgICAgW2tdIHBhZ2VfZmF1bHQNCj4gKyAgIDAuMjQl ICAgICAgICAgIDEzNzQgICAgICAgcG9zdGdyZXMgIHBvc3RncmVzICAgICAgICAgICAgICAgICAg Wy5dIExvZ2ljYWxUYXBlV3JpdGUNCj4gKyAgIDAuMjQlICAgICAgICAgIDQyMDYgICAgICAgIHN3 YXBwZXIgIFtrZXJuZWwua2FsbHN5bXNdICAgICAgICAgW2tdIGludGVsX2lkbGUNCj4gKyAgIDAu MjElICAgICAgICAgIDEyMDYgICAgICAgcG9zdGdyZXMgIHBvc3RncmVzICAgICAgICAgICAgICAg ICAgWy5dIHNsb3RfZ2V0c29tZWF0dHJzDQoNClNhbWUgaGVyZS4NCg0KPiBBbHNvLCBoZXJlIGFy ZSBvdXIgd2FsIHNldHRpbmdzIG9uIHRoZSBtYXN0ZXIuDQo+IERvIHRoZXNlIHNldHRpbmdzIGFw cGVhciBvaz8NCj4NCj4gd2FsX2Jsb2NrX3NpemUgICAgICAgICAgICAgICAgICB8IDgxOTIgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfA0KPiAgIHdhbF9idWZmZXJzICAgICAg ICAgICAgICAgICAgICAgfCAxNk1CICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IHwNCj4gICB3YWxfa2VlcF9zZWdtZW50cyAgICAgICAgICAgICAgIHwgNTAwMCAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICB8DQo+ICAgd2FsX2xldmVsICAgICAgICAgICAgICAg ICAgICAgICB8IGhvdF9zdGFuZGJ5ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfA0KPiAg IHdhbF9yZWNlaXZlcl9zdGF0dXNfaW50ZXJ2YWwgICAgfCAxMHMgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIHwNCj4gICB3YWxfc2VnbWVudF9zaXplICAgICAgICAgICAgICAg IHwgMTZNQiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8DQo+ICAgd2FsX3Nl bmRlcl9kZWxheSAgICAgICAgICAgICAgICB8IDFzICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgfA0KPiAgIHdhbF9zeW5jX21ldGhvZCAgICAgICAgICAgICAgICAgfCBmZGF0 YXN5bmMgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwNCj4gICB3YWxfd3JpdGVyX2Rl bGF5ICAgICAgICAgICAgICAgIHwgMjAwbXMgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICB8DQoNCkxvb2tzIHJlYXNvbmFibGUgdG8gbWUuDQoNClNvLCB0aGUgc3RyYWNlIG91dHB1 dCByZXBlYXRzIHRoaXMsIHdpdGggc21hbGwgdmFyaWF0aW9ucyBpbiB0aGUgbnVtYmVyIG9mIGJ5 dGVzIHdyaXR0ZW4gaW4gZWFjaCBzZW5kdG8oKSBjYWxsOg0KDQpyZWN2ZnJvbSgxMCwgMHg3Zjlk ZmVjMWY3NTMsIDUsIDAsIDAsIDApID0gLTEgRUFHQUlOIChSZXNvdXJjZSB0ZW1wb3JhcmlseSB1 bmF2YWlsYWJsZSkgcmVhZCg3LCAuLi4sIDEzMTA3MikgPSAxMzEwNzIgc2VuZHRvKDEwLCAuLi4s IDM2OTAsIDAsIE5VTEwsIDApID0gMzY5MCBzZW5kdG8oMTAsIC4uLiwgMzYwNSwgMCwgTlVMTCwg MCkgPSAzNjA1IHNlbmR0bygxMCwgLi4uLCAzNjY5LCAwLCBOVUxMLCAwKSA9IDM2Njkgc2VuZHRv KDEwLCAuLi4sIDM2NTMsIDAsIE5VTEwsIDApID0gMzY1MyBzZW5kdG8oMTAsIC4uLiwgMzYzNywg MCwgTlVMTCwgMCkgPSAzNjM3IHNlbmR0bygxMCwgLi4uLCAzNjIxLCAwLCBOVUxMLCAwKSA9IDM2 MjEgc2VuZHRvKDEwLCAuLi4sIDM2NjksIDAsIE5VTEwsIDApID0gMzY2OSBzZW5kdG8oMTAsIC4u LiwgMzYwNSwgMCwgTlVMTCwgMCkgPSAzNjA1IHNlbmR0bygxMCwgLi4uLCA1MywgMCwgTlVMTCwg MCkgPSA1Mw0KZ2V0cHBpZCgpICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgID0gNTQ3NA0K DQpUaGUgcmVhZCgpIHJlYWRzIDEyOGtCIG9mIFdBTCBmcm9tIHRoZSBmaWxlIGluIHBnX3hsb2cs IGFuZCBpdCBpcyB0aGVuIHNlbnQgdG8gdGhlIGNsaWVudC4gTm93LCBpdCdzIHByZXR0eSBzdXJw cmlzaW5nIHRoYXQgdGhlIG51bWJlciBvZiBieXRlcyB3cml0dGVuIHdpdGggc2VuZHRvKCkgZG9l c24ndCBtYXRjaCB0aGUgbnVtYmVyIG9mIGJ5dGVzIHJlYWQgZnJvbSB0aGUgZmlsZS4gVW5sZXNz LCB5b3UncmUgdXNpbmcgU1NMIHdpdGggY29tcHJlc3Npb24uIFRoYXQgd291bGQgYWxzbyBleHBs YWluIHRoZSBoaWdoIGFtb3VudCBvZiBDUFUgdGltZSBzcGVudCBpbiBsaWJ6IGluIHRoZSBwZXJm IG91dHB1dC4NCg0KVHJ5IGRpc2FibGluZyBTU0wgY29tcHJlc3Npb24sIHdpdGggc3NsY29tcHJl c3Npb249MCBvcHRpb24gaW4gcHJpbWFyeV9jb25uaW5mbywgb3IgZGlzYWJsZSBTU0wgYWx0b2dl dGhlciBpZiB0aGUgbmV0d29yayBpcyB0cnVzdHdvcnRoeSBlbm91Z2ggZm9yIHRoYXQuDQoNCi0g SGVpa2tpDQo=
pgsql-bugs by date: