Backend often crashing - Mailing list pgsql-general
| From | gnotari@linkgroup.it |
|---|---|
| Subject | Backend often crashing |
| Date | |
| Msg-id | OFBC159CD4.B139A001-ONC1256CFC.006617BD-C1256CFC.006617DB@linkgroup.it Whole thread Raw |
| Responses |
Re: Backend often crashing
(Tom Lane <tgl@sss.pgh.pa.us>)
|
| List | pgsql-general |
PFA+SSdtIHJlc2VuZGluZyB0aGUgbWVzc2FnZSBhcyBhIHJlbWluZGVyLjwv UD48UD5JJ20gYWRkaW5nIG15IGZpbmRpbmdzIGF0IHRoZSBib3R0b20uPC9Q PjxQPiZuYnNwOzwvUD48UD4mZ3Q7PEZPTlQgRkFDRT0iQ291cmllciI+SSBo YXZlIG9uZSBvZiB0aG9zZSBuYXN0eSBwcm9ibGVtcywgd2l0aCBQb3N0Z3Jl cyBiYWNrZW5kIG9mdGVuIGNyYXNoaW5nPEJSPiZndDt3aXRoIHNpZ25hbCAx MS48QlI+Jmd0OzwvRk9OVD48QlI+Jmd0OzxGT05UIEZBQ0U9IkNvdXJpZXIi PkknbGwgZG8gbXkgYmVzdCB0byBnaXZlIHlvdSB0aGUgZGV0YWlsczo8QlI+ Jmd0OzwvRk9OVD48QlI+Jmd0OzxGT05UIEZBQ0U9IkNvdXJpZXIiPlBvc3Rn cmVzIGlzIDcuMi4xLCBtb3JlIGV4YWN0bHkgaXMgRGViaWFuIHBhY2thZ2Ug Ny4yLjEtMiBmcm9tIHRoZSBTdGFibGU8QlI+Jmd0OyhXb29keSkgZGlzdHJp YnV0aW9uIC0tIEknbSBmb3J3YXJkaW5nIGNvcHkgb2YgdGhpcyBtZXNzYWdl IHRvIERlYmlhbidzPEJSPiZndDtwYWNrYWdlIG1hbnRhaW5lci48QlI+Jmd0 OzwvRk9OVD48QlI+Jmd0OzxGT05UIEZBQ0U9IkNvdXJpZXIiPlBvc3RncmVz IGlzIHJ1bm5pbmcgYXMgYSBiYWNrZW5kIGZvciBhIHdlbGwga25vd24gaXRh bGlhbiB3ZWIgc2l0ZSwgcnVubmluZzxCUj4mZ3Q7b24gWm9wZSAodmVyc2lv biAyLjYuMSB3aXRoIHBzeWNvcGcgUHl0aG9uIGFkYXB0ZXIsIHYuMS4xKTxC Uj4mZ3Q7PC9GT05UPjxCUj4mZ3Q7PEZPTlQgRkFDRT0iQ291cmllciI+VGhl IHByb2JsZW0gaXMgcmVjZW50LCBpLmUuIG5ldmVyIGhhcHBlbmVkIHVudGls IGxhc3QgbW9udGggb3Igc28sIG9uIHRoaXM8QlI+Jmd0O3NhbWUgc2V0dXAu PEJSPiZndDtJIGhhdmUgYSBmZXcgb3RoZXIgbWFjaGluZXMsIHJ1bm5pbmcg dGhlIHNhbWUgc29mdHdhcmUgc2V0dXAsIGJ1dCBkaWZmZXJlbnQ8QlI+Jmd0 O1pvcGUgc2l0ZXMsIG5ldmVyIGV4cGVyaWVuY2luZyBhbnkgcHJvYmxlbS48 QlI+Jmd0OzwvRk9OVD48QlI+Jmd0OzxGT05UIEZBQ0U9IkNvdXJpZXIiPlRo ZXNlIGFyZSB0aGUgcmVsZXZhbnQgbGluZXMgZnJvbSBzeXNsb2c8QlI+Jmd0 OzwvRk9OVD48QlI+Jmd0OzxGT05UIEZBQ0U9IkNvdXJpZXIiPkZlYiAyMCAx NDo0Mzo1MyBzcGVlZCBwb3N0Z3Jlc1sxMzM2NV06IFsyNV0gREVCVUc6ICZu YnNwO3NlcnZlciBwcm9jZXNzIChwaWQ8QlI+Jmd0OzE1OTA2KSB3YXMgdGVy bWluYXRlZCBieSBzaWduYWwgMTE8QlI+Jmd0O0ZlYiAyMCAxNDo0Mzo1MyBz cGVlZCBwb3N0Z3Jlc1sxMzM2NV06IFsyNl0gREVCVUc6ICZuYnNwO3Rlcm1p bmF0aW5nIGFueSBvdGhlcjxCUj4mZ3Q7YWN0aXZlIHNlcnZlciBwcm9jZXNz ZXM8QlI+Jmd0O0ZlYiAyMCAxNDo0Mzo1MyBzcGVlZCBwb3N0Z3Jlc1sxNTkw OF06IFsyNi0xXSBOT1RJQ0U6ICZuYnNwO01lc3NhZ2UgZnJvbTxCUj4mZ3Q7 UG9zdGdyZVNRTCBiYWNrZW5kOjxCUj4mZ3Q7RmViIDIwIDE0OjQzOjUzIHNw ZWVkIHBvc3RncmVzWzE1OTA4XTogWzI2LTJdIF5JVGhlIFBvc3RtYXN0ZXIg aGFzIGluZm9ybWVkPEJSPiZndDttZSB0aGF0IHNvbWUgb3RoZXIgYmFja2Vu ZDxCUj4mZ3Q7RmViIDIwIDE0OjQzOjUzIHNwZWVkIHBvc3RncmVzWzE1OTA4 XTogWzI2LTNdIF5JZGllZCBhYm5vcm1hbGx5IGFuZDxCUj4mZ3Q7cG9zc2li bHkgY29ycnVwdGVkIHNoYXJlZCBtZW1vcnkuPEJSPiZndDtGZWIgMjAgMTQ6 NDM6NTMgc3BlZWQgcG9zdGdyZXNbMTU5MDhdOiBbMjYtNF0gXklJIGhhdmUg cm9sbGVkIGJhY2sgdGhlPEJSPiZndDtjdXJyZW50IHRyYW5zYWN0aW9uIGFu ZCBhbTxCUj4mZ3Q7RmViIDIwIDE0OjQzOjUzIHNwZWVkIHBvc3RncmVzWzE1 OTA4XTogWzI2LTVdIF5JZ29pbmcgdG8gdGVybWluYXRlIHlvdXI8QlI+Jmd0 O2RhdGFiYXNlIHN5c3RlbSBjb25uZWN0aW9uIGFuZCBleGl0LjxCUj4mZ3Q7 RmViIDIwIDE0OjQzOjUzIHNwZWVkIHBvc3RncmVzWzE1OTA4XTogWzI2LTZd IF5JUGxlYXNlIHJlY29ubmVjdCB0byB0aGU8QlI+Jmd0O2RhdGFiYXNlIHN5 c3RlbSBhbmQgcmVwZWF0IHlvdXIgcXVlcnkuPEJSPiZndDtGZWIgMjAgMTQ6 NDM6NTMgc3BlZWQgcG9zdGdyZXNbMTU5MDRdOiBbMjYtMV0gTk9USUNFOiAm bmJzcDtNZXNzYWdlIGZyb208QlI+Jmd0O1Bvc3RncmVTUUwgYmFja2VuZDo8 QlI+Jmd0O0ZlYiAyMCAxNDo0Mzo1MyBzcGVlZCBwb3N0Z3Jlc1sxNTkwNF06 IFsyNi0yXSBeSVRoZSBQb3N0bWFzdGVyIGhhcyBpbmZvcm1lZDxCUj4mZ3Q7 bWUgdGhhdCBzb21lIG90aGVyIGJhY2tlbmQ8QlI+Jmd0O0ZlYiAyMCAxNDo0 Mzo1MyBzcGVlZCBwb3N0Z3Jlc1sxNTkwNF06IFsyNi0zXSBeSWRpZWQgYWJu b3JtYWxseSBhbmQ8QlI+Jmd0O3Bvc3NpYmx5IGNvcnJ1cHRlZCBzaGFyZWQg bWVtb3J5LjxCUj4mZ3Q7RmViIDIwIDE0OjQzOjUzIHNwZWVkIHBvc3RncmVz WzE1OTA0XTogWzI2LTRdIF5JSSBoYXZlIHJvbGxlZCBiYWNrIHRoZTxCUj4m Z3Q7Y3VycmVudCB0cmFuc2FjdGlvbiBhbmQgYW08QlI+Jmd0OzwvRk9OVD48 QlI+Jmd0OzxGT05UIEZBQ0U9IkNvdXJpZXIiPkkgaW1tZWRpYXRlbHkgdGhv dWdodCBvZiBhbiBoYXJkd2FyZSBwcm9ibGVtIGJ1dCwgaGF2aW5nIGFuIGVx dWl2YWxlbnQ8QlI+Jmd0O21hY2hpbmUgb25saW5lLCBJIGR1bXBlZCB0aGUg ZGIgYW5kIG1vdmVkIHRvIHRoYXQuPEJSPiZndDtUaGUgcHJvYmxlbSBtYW5p ZmVzdGF0ZWQgYXQgb25jZSBvbiB0aGUgb3RoZXIgbWFjaGluZSwgd2hpY2gg aGFkIHByZXZpb3VzbHk8QlI+Jmd0Oyh+MSBtb250aCBiZWZvcmUpICZuYnNw O3J1biB0aGUgc2l0ZSB3aXRob3V0IGFueSBlcnJvci48QlI+Jmd0OzwvRk9O VD48QlI+Jmd0OzxGT05UIEZBQ0U9IkNvdXJpZXIiPlRoZSB0d28gbWFjaGlu ZXMgaGF2ZSB0aGUgc2FtZSBzb2Z0d2FyZSBzZXR1cCwgYnV0IGRpZmZlcmVu dCBMaW51eCBrZXJuZWxzPEJSPiZndDsoMi40LjE5IHZzIDIuNC4yMCwgcmVp c2VyZnMgdnMgZXh0MyksIGFuZCBkaWZmZXJlbnQgaGFyZHdhcmUuPEJSPiZn dDs8L0ZPTlQ+PEJSPiZndDs8Rk9OVCBGQUNFPSJDb3VyaWVyIj5JIGNhbm5v dCByZXByb2R1Y2UgdGhlIHByb2JsZW0gcmVsaWFibHksIHRob3VnaCBvbiB0 aGUgcHJvZHVjdGlvbiBtYWNoaW5lPEJSPiZndDt0aGUgZGF0YWJhc2UgY3Jh c2hlcyBtYW55IHRpbWVzIGFuIGhvdXIuPEJSPiZndDs8L0ZPTlQ+PEJSPiZn dDs8Rk9OVCBGQUNFPSJDb3VyaWVyIj5JdCBfc2VlbXNfIHRvIGJlIHJlbGF0 ZWQgdG8gc29tZSBtaWxkbHkgY29udm9sdXRlZCBxdWVyeSAoYSBTRUxFQ1Qg b25seTxCUj4mZ3Q7cXVlcnkpLiBSdW5uaW5nIHRoYXQgcXVlcnkgbWFudWFs bHksIEkgbWFuYWdlZCB0byBjcmFzaCB0aGUgYmFja2VuZCBvbmx5PEJSPiZn dDtvbmNlLjxCUj4mZ3Q7VkFDVVVNIEZVTEwgbmV2ZXIgZ2F2ZSBhbnkgZXJy b3IsIG5vciBkaWQgcGdfZHVtcC48QlI+Jmd0OzwvRk9OVD48QlI+Jmd0OzxG T05UIEZBQ0U9IkNvdXJpZXIiPkkgb2J0YWluZWQgc29tZSAocHJldHR5IGxh cmdlLCB+OTBNQikgY29yZSBmaWxlcyBmcm9tIHRoZSBjcmFzaGVzLiBUaGU8 QlI+Jmd0O2JhY2t0cmFjZSBpcyBjb25zaXN0ZW50IGJldHdlZW4gdGhlIGZp bGVzLCBoZXJlIGl0IGlzOjxCUj4mZ3Q7PC9GT05UPjxCUj4mZ3Q7PEZPTlQg RkFDRT0iQ291cmllciI+IzAgJm5ic3A7MHgwODE1N2U5MiBpbiBNZW1vcnlD b250ZXh0UmVzZXQgKCk8QlI+Jmd0OyMxICZuYnNwOzB4MDgxNTdlYjkgaW4g TWVtb3J5Q29udGV4dFJlc2V0Q2hpbGRyZW4gKCk8QlI+Jmd0OyMyICZuYnNw OzB4MDgxNTdlOGIgaW4gTWVtb3J5Q29udGV4dFJlc2V0ICgpPEJSPiZndDsj MyAmbmJzcDsweDA4MTU3ZWI5IGluIE1lbW9yeUNvbnRleHRSZXNldENoaWxk cmVuICgpPEJSPiZndDsjNCAmbmJzcDsweDA4MTU3ZThiIGluIE1lbW9yeUNv bnRleHRSZXNldCAoKTxCUj4mZ3Q7IzUgJm5ic3A7MHgwODBjNWM4OCBpbiBF eGVjU2NhbiAoKTxCUj4mZ3Q7IzYgJm5ic3A7MHgwODBjYjYxYSBpbiBFeGVj U2VxU2NhbiAoKTxCUj4mZ3Q7IzcgJm5ic3A7MHgwODBjNDEzOSBpbiBFeGVj UHJvY05vZGUgKCk8QlI+Jmd0OyM4ICZuYnNwOzB4MDgwY2JlMmMgaW4gRXhl Y1NvcnQgKCk8QlI+Jmd0OyM5ICZuYnNwOzB4MDgwYzQxYzkgaW4gRXhlY1By b2NOb2RlICgpPEJSPiZndDsjMTAgMHgwODBjYTYzMCBpbiBFeGVjTWVyZ2VK b2luICgpPEJSPiZndDsjMTEgMHgwODBjNDE4OSBpbiBFeGVjUHJvY05vZGUg KCk8QlI+Jmd0OyMxMiAweDA4MGNiZTJjIGluIEV4ZWNTb3J0ICgpPEJSPiZn dDsjMTMgMHgwODBjNDFjOSBpbiBFeGVjUHJvY05vZGUgKCk8QlI+Jmd0OyMx NCAweDA4MGNjMGFlIGluIEV4ZWNVbmlxdWUgKCk8QlI+Jmd0OyMxNSAweDA4 MGM0MWQ5IGluIEV4ZWNQcm9jTm9kZSAoKTxCUj4mZ3Q7IzE2IDB4MDgwY2Q1 ZDUgaW4gRXhlY1JlU2NhblNldFBhcmFtUGxhbiAoKTxCUj4mZ3Q7IzE3IDB4 MDgwYzVjYWMgaW4gRXhlY1NjYW4gKCk8QlI+Jmd0OyMxOCAweDA4MGNkNWY2 IGluIEV4ZWNTdWJxdWVyeVNjYW4gKCk8QlI+Jmd0OyMxOSAweDA4MGM0MTY5 IGluIEV4ZWNQcm9jTm9kZSAoKTxCUj4mZ3Q7IzIwIDB4MDgwYzczZjggaW4g RXhlY1Byb2NBcHBlbmQgKCk8QlI+Jmd0OyMyMSAweDA4MGM0MTI5IGluIEV4 ZWNQcm9jTm9kZSAoKTxCUj4mZ3Q7IzIyIDB4MDgwY2JlMmMgaW4gRXhlY1Nv cnQgKCk8QlI+Jmd0OyMyMyAweDA4MGM0MWM5IGluIEV4ZWNQcm9jTm9kZSAo KTxCUj4mZ3Q7IzI0IDB4MDgwY2I5YTYgaW4gRXhlY1NldE9wICgpPEJSPiZn dDsjMjUgMHgwODBjNDFlOSBpbiBFeGVjUHJvY05vZGUgKCk8QlI+Jmd0OyMy NiAweDA4MGNiZTJjIGluIEV4ZWNTb3J0ICgpPEJSPiZndDsjMjcgMHgwODBj NDFjOSBpbiBFeGVjUHJvY05vZGUgKCk8QlI+Jmd0OyMyOCAweDA4MGMzMGZl IGluIEV4ZWN1dG9yRW5kICgpPEJSPiZndDsjMjkgMHgwODBjMjc5NyBpbiBF eGVjdXRvclJ1biAoKTxCUj4mZ3Q7IzMwIDB4MDgxMTA0ZGUgaW4gUHJvY2Vz c1F1ZXJ5ICgpPEJSPiZndDsjMzEgMHgwODEwZWQ3MCBpbiBwZ19leGVjX3F1 ZXJ5X3N0cmluZyAoKTxCUj4mZ3Q7IzMyIDB4MDgxMGZkNWUgaW4gUG9zdGdy ZXNNYWluICgpPEJSPiZndDsjMzMgMHgwODBmNmQ0ZSBpbiBDbG9zZVBvc3Rt YXN0ZXJQb3J0cyAoKTxCUj4mZ3Q7IzM0IDB4MDgwZjY2OWYgaW4gQ2xvc2VQ b3N0bWFzdGVyUG9ydHMgKCk8QlI+Jmd0OyMzNSAweDA4MGY1ODgyIGluIFBv c3RtYXN0ZXJNYWluICgpPEJSPiZndDsjMzYgMHgwODBmNTM5MSBpbiBQb3N0 bWFzdGVyTWFpbiAoKTxCUj4mZ3Q7IzM3IDB4MDgwZDRlMTggaW4gbWFpbiAo KTxCUj4mZ3Q7IzM4IDB4NDAxZDExNGYgaW4gX19saWJjX3N0YXJ0X21haW4g KCkgZnJvbSAvbGliL2xpYmMuc28uNjwvRk9OVD48L1A+PFA+Jm5ic3A7PC9Q PjxQPjxGT05UIEZBQ0U9IkNvdXJpZXIiPkFzIGl0IHR1cm5lZCBvdXQsIHN3 aXRjaGluZyB0byA3LjIuNCBnYXZlIG5vIHJlc3VsdC4gVGhlIGVycm9ycyBh cmUgc3RpbGwgdGhlcmUuPC9GT05UPjwvUD48UD48Rk9OVCBGQUNFPSJDb3Vy aWVyIj5CdXQsIG5vdywgYXQgbGVhc3QgSSd2ZSBhIGNsdWUuIEl0IHNlZW1l ZCB0aGF0IHRoZSBlcnJvciB3YXMgdHJpZ2dlcmVkIGFsbW9zdCBleGNsdXNp dmVseSBieSBhIHNlYXJjaCBmdW5jaW9uIG9uIHRoZSB3ZWIgc2l0ZS4gPC9G T05UPjwvUD48UD48Rk9OVCBGQUNFPSJDb3VyaWVyIj5UaGUgY29kZSB0dXJu ZWQgb3V0IHRvIGNhbGwgZXh0ZW5zaXZlbHkgdGhlIHRvX2FzY2lpKCkgZnVu Y3Rpb24gb2YgUG9zdGdyZXMuICZuYnNwO0kgaGF2ZSByZWFzb24gdG8gc3Vz cGVjdCB0aGF0IHRoZSBkYXRhYmFzZSBjb250YWlucywgaW4gdGV4dCBmaWVs ZHMsIGNoYXJhY3RlcnMgd2hpY2ggZG8gbm90IHBlcnRhaW4gdG8gdGhlIHNl bGVjdGVkIGVuY29kaW5nIChMQVRJTjEpLjwvRk9OVD48L1A+PFA+PEZPTlQg RkFDRT0iQ291cmllciI+U28sIEkgZmFuY2llZCwgb25lIHBvc3NpYmxlIGN1 bHByaXQgd2FzIHRoZSB0b19hc2NpaSBmdW5jdGlvbiBjaG9ja2luZyBvbiBz b21lIHN0cmFuZ2UgY2hhcmFjdGVyLjwvRk9OVD48L1A+PFA+PEZPTlQgRkFD RT0iQ291cmllciI+SSByZXBsYWNlZCB0aGUgb2NjdXJlbmNlcyBvZiB0b19h c2NpaSB3aXRoIGEgY3VzdHVtIGZ1bmN0aW9uIHRoYXQgY2FsbHMgdG9fYXNj aWkgb25seSBvbiB0aGUgcmVzdWx0IG9mIGEgdHJhbnNsYXRlLCB3aGljaCBp biB0dXJuIGNvbnZlcnRzIHNvbWUgc3RyYW5nZSAocnVzc2lhbj8pIGNoYXJh Y3RlcnMgdG8gcGxhaW4gYXNjaWkuPC9GT05UPjwvUD48UD48Rk9OVCBGQUNF PSJDb3VyaWVyIj5UaGUgZXJyb3JzIGRyb3BwZWQgZG93biwgdGhlIGZldyBy ZW1haW5pbmcgZG9uJ3Qgc2VlbSB0byBiZSByZWxhdGVkIHRvIHRoYXQgc2Vh cmNoIGZ1bmN0aW9uLjwvRk9OVD48L1A+PFA+PEZPTlQgRkFDRT0iQ291cmll ciI+T2YgY291cnNlLCB0aGlzIGlzIG5vdCBjb25jbHVzaXZlLCBJJ3ZlIHll dCB0byByZXByb2R1Y2UgcmVsaWFibHkgdGhlIGVycm9yIG9uIGEgc2luZ2xl LCBzZWxlY3RlZCBkYXRhIHJvdywgYnV0IEkgdGhpbmsgd2hhdCBpIGZvdW5k IGl0J3Mgd29ydGggcmVwb3J0aW5nLjwvRk9OVD48L1A+PFA+Jm5ic3A7PC9Q PjxQPjxGT05UIEZBQ0U9IkNvdXJpZXIiPlRoYW5rcyB0byB0aGUgZGV2ZWxv cGluZyB0ZWFtITwvRk9OVD48L1A+PFA+Jm5ic3A7PC9QPjxQPjxGT05UIEZB Q0U9IkNvdXJpZXIiPmNpYW88L0ZPTlQ+PC9QPjxQPjxGT05UIEZBQ0U9IkNv dXJpZXIiPkd1aWRvPC9GT05UPjwvUD48UD48L1A+
pgsql-general by date: