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 84CE67AB46ACDA41B18094177DD0853D212241@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>)
Responses Re: BUG #9635: Wal sender process is using 100% CPU  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-bugs
SGkgSGVpa2tpLA0KDQpJIHBlcmZvcm1lZCBhbiBzdHJhY2Ugb24gb25lIG9mIHRoZSBwaWRzIHRo
YXQgd2FzIGNvbnN1bWluZyAxMDAlIG9mIHRoZSBjcHUuIA0KVGhpcyBpcyBqdXN0IGEgcG9ydGlv
biBvZiB0aGUgbG9nLg0KSSBhbHNvIHRyaW1tZWQgb3V0IHNvbWUgZGF0YSBwcm92aWRlZCBpbiB0
aGUgcXVvdGVzIGluIHRoZSByZWFkIGFuZCBzZW5kcywgbm90IHN1cmUgaWYgeW91IG5lZWQgaXQu
DQpBIG1ham9yaXR5IG9mIHRoZSBjYWxscyBpbiB0aGUgdHJhY2UgbG9nIHdlcmUgcmVjdmZyb20o
KSBhbmQgc2VuZHRvKCkuDQpFQUdBSU4gKFJlc291cmNlIHRlbXBvcmFyaWx5IHVuYXZhaWxhYmxl
KSBjYW1lIHVwIHRpbWUgYW5kIHRpbWUgYWdhaW4uDQoNCiMgc3RyYWNlIGxvZyBkdXJpbmcgMTAw
JSBjcHUgdXRpbGl6YXRpb24gb24gdGhlIG1hc3Rlcg0KDQpnZXRwcGlkKCkgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgPSA1NDc0DQpyZWN2ZnJvbSgxMCwgMHg3ZjVkZ2FjMWY3NTMsIDUs
IDAsIDAsIDApID0gLTEgRUFHQUlOIChSZXNvdXJjZSB0ZW1wb3JhcmlseSB1bmF2YWlsYWJsZSkN
CnJlYWQoNywgIiIuLi4sIDEzMTA3MikgPSAxMzEwNzINCnNlbmR0bygxMCwgIiIuLi4sIDMxNzgs
IDAsIE5VTEwsIDApID0gMzE3OA0Kc2VuZHRvKDEwLCAiIi4uLiwgNTM4MSwgMCwgTlVMTCwgMCkg
PSA1MzgxDQpnZXRwcGlkKCkgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPSA1NDc0DQpy
ZWN2ZnJvbSgxMCwgMHg3ZjVkZ2FjMWY3NTMsIDUsIDAsIDAsIDApID0gLTEgRUFHQUlOIChSZXNv
dXJjZSB0ZW1wb3JhcmlseSB1bmF2YWlsYWJsZSkNCnJlYWQoNywgIiIuLi4sIDEzMTA3MikgPSAx
MzEwNzINCnNlbmR0bygxMCwgIiIuLi4sIDMzMzgsIDAsIE5VTEwsIDApID0gMzMzOA0KZ2V0cHBp
ZCgpICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgID0gNTQ3NA0KcmVjdmZyb20oMTAsICIg
IiwgNSwgMCwgTlVMTCwgTlVMTCkgPSA1DQpyZWN2ZnJvbSgxMCwgIiIsIDMyLCAwLCBOVUxMLCBO
VUxMKSA9IDMyDQpyZWN2ZnJvbSgxMCwgIiIsIDUsIDAsIE5VTEwsIE5VTEwpID0gNQ0KcmVjdmZy
b20oMTAsICIiLi4uLCA0OCwgMCwgTlVMTCwgTlVMTCkgPSA0OA0KZmNudGwoMTAsIEZfR0VURkwp
ICAgICAgICAgICAgICAgICAgICAgID0gMHg4MDIgKGZsYWdzIE9fUkRXUnxPX05PTkJMT0NLKQ0K
ZmNudGwoMTAsIEZfU0VURkwsIE9fUkRXUikgICAgICAgICAgICAgID0gMA0KZmNudGwoMTAsIEZf
U0VURkwsIE9fUkRPTkxZfE9fTk9OQkxPQ0spID0gMA0KcmVjdmZyb20oMTAsIDB4N2Y1ZGdhYzFm
NzUzLCA1LCAwLCAwLCAwKSA9IC0xIEVBR0FJTiAoUmVzb3VyY2UgdGVtcG9yYXJpbHkgdW5hdmFp
bGFibGUpDQpzZWxlY3QoMTEsIFszIDEwXSwgWzEwXSwgTlVMTCwgezEsIDB9KSAgPSA/IEVSRVNU
QVJUTk9IQU5EIChUbyBiZSByZXN0YXJ0ZWQpDQotLS0gU0lHVVNSMSAoVXNlciBkZWZpbmVkIHNp
Z25hbCAxKSBAIDAgKDApIC0tLQ0Kd3JpdGUoNiwgIlwwIiwgMSkgICAgICAgICAgICAgICAgICAg
ICAgID0gMQ0KcnRfc2lncmV0dXJuKDB4NikgICAgICAgICAgICAgICAgICAgICAgID0gLTEgRUlO
VFIgKEludGVycnVwdGVkIHN5c3RlbSBjYWxsKQ0KcmVhZCgzLCAiXDAiLCAxNikgICAgICAgICAg
ICAgICAgICAgICAgID0gMQ0KZ2V0cHBpZCgpICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ID0gNTQ3NA0KcmVjdmZyb20oMTAsIDUsIDAsIDAsIDApID0gLTEgRUFHQUlOIChSZXNvdXJjZSB0
ZW1wb3JhcmlseSB1bmF2YWlsYWJsZSkNCnNlbmR0bygxMCwgIiIuLi4sIDI3MTUsIDAsIE5VTEws
IDApID0gLTEgRUFHQUlOIChSZXNvdXJjZSB0ZW1wb3JhcmlseSB1bmF2YWlsYWJsZSkNCnJlYWQo
MywgMHg3ZmZsOTYxYjA3ODAsIDE2KSAgICAgICAgICAgICA9IC0xIEVBR0FJTiAoUmVzb3VyY2Ug
dGVtcG9yYXJpbHkgdW5hdmFpbGFibGUpDQpzZWxlY3QoMTEsIFszIDEwXSwgWzEwXSwgTlVMTCwg
ezEsIDB9KSAgPSA/IEVSRVNUQVJUTk9IQU5EIChUbyBiZSByZXN0YXJ0ZWQpDQotLS0gU0lHVVNS
MSAoVXNlciBkZWZpbmVkIHNpZ25hbCAxKSBAIDAgKDApIC0tLQ0Kd3JpdGUoNiwgIlwwIiwgMSkg
ICAgICAgICAgICAgICAgICAgICAgID0gMQ0KcnRfc2lncmV0dXJuKDB4NikgICAgICAgICAgICAg
ICAgICAgICAgID0gLTEgRUlOVFIgKEludGVycnVwdGVkIHN5c3RlbSBjYWxsKQ0KcmVhZCgzLCAi
XDAiLCAxNikgICAgICAgICAgICAgICAgICAgICAgID0gMQ0KZ2V0cHBpZCgpICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgID0gNTQ3NA0KDQpJIGN1cnJlbnRseSBkb24ndCBoYXZlIHBlcmYg
aW5zdGFsbGVkLg0KSSBjYW4gZ2V0IHRoYXQgaW5zdGFsbGVkIGFuZCBzZW5kIHJlc3VsdHMgaWYg
eW91IG5lZWQgaXQuDQoNClRoYW5rcyENCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZy
b206IEhlaWtraSBMaW5uYWthbmdhcyBbbWFpbHRvOmhsaW5uYWthbmdhc0B2bXdhcmUuY29tXSAN
ClNlbnQ6IFR1ZXNkYXksIE1hcmNoIDI1LCAyMDE0IDQ6NDQgQU0NClRvOiBKYW1pZSBLb2Nlbmlh
aw0KQ2M6IHBnc3FsLWJ1Z3NAcG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IFJlOiBbQlVHU10gQlVH
ICM5NjM1OiBXYWwgc2VuZGVyIHByb2Nlc3MgaXMgdXNpbmcgMTAwJSBDUFUNCg0KT24gMDMvMTkv
MjAxNCAwNzoxMyBQTSwgamtvY2VuaWFrQG1lZGlhbWF0aC5jb20gd3JvdGU6DQo+IFRoZSBmb2xs
b3dpbmcgYnVnIGhhcyBiZWVuIGxvZ2dlZCBvbiB0aGUgd2Vic2l0ZToNCj4NCj4gQnVnIHJlZmVy
ZW5jZTogICAgICA5NjM1DQo+IExvZ2dlZCBieTogICAgICAgICAgSmFtaWUgS29jZW5pYWsNCj4g
RW1haWwgYWRkcmVzczogICAgICBqa29jZW5pYWtAbWVkaWFtYXRoLmNvbQ0KPiBQb3N0Z3JlU1FM
IHZlcnNpb246IDkuMS45DQo+IE9wZXJhdGluZyBzeXN0ZW06ICAgeDg2XzY0LXVua25vd24tbGlu
dXgtZ251IChEZWJpYW4gNC43LjItNSkgNjQtYml0DQo+IERlc2NyaXB0aW9uOg0KPg0KPiBQZXJp
b2RpY2FsbHkgdGhyb3VnaG91dCB0aGUgZGF5LCB3ZSBrZWVwIHNlZWluZyB0aGUgd2FsIHNlbmRl
ciBwcm9jZXNzIA0KPiB1dGlsaXplIDEwMCUgb2YgdGhlIENQVS4gV2UgYmVnYW4gbm90aWNpbmcg
dGhpcyBhZnRlciB3ZSBhZGRlZCAyIG5ldyANCj4gc2xhdmUgc2VydmVycywgZ29pbmcgZnJvbSAy
IHRvIDQgc2xhdmVzLiBTZWUgdG9wIHJlc3VsdHMgYW5kIEkgYWxzbyANCj4gaW5jbHVkZWQgb3Vy
IHdhbCBzZXR0aW5ncy4gVGhhbmtzIQ0KDQpIbW0uIFRoZXJlIHdhcyBhIGJ1ZyB0aGF0IGNhdXNl
ZCB3YWxzZW5kZXIgdG8gZ28gaW50byBhIGJ1c3ktbG9vcCwgd2hlbiB0aGUgc3RhbmRieSBkaXNj
b25uZWN0ZWQuIEJ1dCB0aGF0IHdhcyBmaXhlZCBpbiA5LjEuNCBhbHJlYWR5Lg0KDQpDb3VsZCB5
b3UgYXR0YWNoIHRvIG9uZSBvZiB0aGUgcHJvY2Vzc2VzIHdpdGggZ2RiIGFuZCBzZWUgd2hhdCBm
dW5jdGlvbnMgYXJlIGJlaW5nIGNhbGxlZD8gT3Igc3RyYWNlLCBvciAicGVyZiB0b3AiIG9yIHNv
bWV0aGluZy4NCg0KLSBIZWlra2kNCg==

pgsql-bugs by date:

Previous
From: Nick Rupley
Date:
Subject: Re: BUG #10189: Limit in 9.3.4 no longer works when ordering using a composite multi-type index
Next
From: wayneh
Date:
Subject: Re: BUG #10189: Limit in 9.3.4 no longer works when ordering using a composite multi-type index